SUMMARY

• Certified Sr. SQL Server DBA wif 9 Years and 4 months of experience in MS SQL SERVER 2017/2014/2012 , 2008R2/2008/2005 Database Administration in Production, Test and Development and SIT environment.
• Hands on Experience in Amazon web services Like IAM, EC2, EBS, S3, RDS (SQL Server) Cloud watch and CLI tool.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2019/2017/2016/2014/2012/2008 R 2/2008/2005.
• Expertise & Hands on experience on SQL server migration activities from SQL 2000/ 2005/2008/2008 R2 to SQL 2012/2014/2016/20017.
• Experience in building policies for access control and user profiles using AWS IAM, S3 controls wif bucket policies.
• Expertise in Querying RDBMS such as SQL Server and RDS.
• Expertise in DMS activities such as on - premise SQL server to AWS Aurora Postgres and Redshift.
• Expertise in DMS activities such as on- premise Oracle databases to AWS Aurora Postgres and Redshift.
• Expertise in DMS activities such as on- premise PostgreSQL to AWS aurora Postgres and Redshift.
• Experience in handling very large databases in OLTP and data warehouse environments, which are in Terabytes size.
• Experience in documenting and implementing Disaster Recovery Plans using Database Mirroring, Log shipping and Replication wif different topologies for production databases.
• Expert in RDBMS software installation, database server builds, applying patches, applying patches in VM environments (VTM), upgrading, configuring, troubleshooting of SQL SERVER on Windows 2003/08/12/16 servers and Clustered VMware Environments.
• Expertise in new features Data Compression, Transparent Data Encryption (TDE), Resource Governor, Policy Based Management, Backup Compression and Change data capture.
• Knowledge in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
• Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
• Experience wif AlwaysON Availability groups, clustering, replication, log shipping, mirroring and storage replication technologies
• Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning teh long running Queries and Store Procedures by examining teh execution plans.
• Hands on experience in troubleshoot teh tempdb growth and configuration settings.
• Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
• Excellent skills in database Backup, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.
• Hands on experience using DMVs and DMFs to finding and solving Performance Issue.
• Expert in Detecting and Resolving Locks and Deadlocks using teh Trace Flags and Native tools like Profiler and teh Activity Monitor.
• Expert in creating and debugging Views, Functions, Indexes, Cursors, Stored Procedures, Triggers, optimizing code and improving Efficiency.
• Basic knowledge in MongoDB database architecture and Primary components.
• Good knowledge & experience on Cloud Computing like Azure/AWS
• Expert in migrating teh DTS Packages to SSIS Packages by using Package Migration Wizard.
• Worked Extensively on ETL process using SSIS packages.
• Expertise in configure teh PerfMon and Extended Events to troubleshoot teh performance issues.
• 24/7 on call production support.
• Hands on experience on ITIL process.
• Experience in Server administration in various environments - Window 2000 & 2003 wif Active Directory Services (AD, DNS, DHCP).
• Experience in In-Place upgrade of Windows serves from 2008 R2 to 2016.
• Expertise in automating teh system by using System Center Operations Manager (SCOM).
• Hands on experience on configure teh Solarwinds DPA alerts.
• Basic knowledge on SAP ME/MII application.
• Thorough understanding of Windows OS as well as Powershell scripting and Active Directory integrations wif SQL Server.
• Expert in raising teh Service Requests and keep tracking of requests.
• Good Team player, Strong Communication skills and interpersonal wif Self-motivation.

TECHNICAL SKILLS

Relational Databases: SQL Server 2019/2017/ 2 / R2/Postgres/Oracle

Database Tools: SSMS, Query Analyzer, SQL Profiler, BCP, ODBC, SQL OLEDB, DBCC, DTA, PerfMon, Extended Events, ADO, ADO.NET, Business Intelligence Studio(SSISLanguages C#, XML,HTML, SQL, T-SQL

Operating Systems: Windows 2016, Windows 2012, Windows 2008R2, Windows 2003, UNIX. AWS EC2.

Web Servers: IIS 5.0/6.0/7.0, Amazon web services (AWS), Virtual Private Cloud (VPC).

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSIS, SSRS, DTS.

Virtualization: VMWare ESX/ESXi, Amazon AWS/EC2.

Monitoring: Solar winds DPA, App dynamics.

Ticketing Tool: ITSM, Cherwell, Service Center

Cloud Computing: AWS (EC2, ELB, S3), Azure, AWS Elasticache, Cloud Formation, Cloud Watch, CloudTrail, IAM, CloudFront, Glacier, Route53, RDS, DMS.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005/2008 , MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor. Active Directory, SQL Navigator, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerformancePoint, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerformancePoint,, Site Recovery Manager (SRM), SAP ME/MII., Terraform, Ansible

Environment: s: SIT/DEV/QA/Production

PROFESSIONAL EXPERIENCE

Confidential - Bakersfield, CA

SQL server Database Administrator

Responsibilities:

• Understanding teh architecture and design of on premise applications before designing and architecting AWS infrastructure for configuring, building and deploying teh application.
• Automating teh implementation using Ansible scriptsso that teh entire application is configured, built.
• Maintained teh monitoring and alerting of production and corporate servers using Cloud Watch service.
• Experienced in creating RDS instances to serve data through servers for responding to requests.
• Created snapshots to take backups of teh volumes and also images to store launch configurations of teh EC2 instances.
• Written Templates forAWSinfrastructure as a code using Terraform to build staging and production environments.
• Managed Amazon redshift clusters such as launching teh cluster by specifying teh nodes and performing teh data analysis queries.
• Worked on teh databases of teh Amazon RDS and carried out functionalities for creating instances as per teh requirements.
• Implemented Amazon RDS multi-AZ for automatic failover and high availability at teh database tier.
• Created CloudFront distributions to serve content from edge locations to users so as to minimize teh load on teh frontend servers.
• Worked on migrate teh data from on- premise SQL server208R2 and SQL server 2016 to AWS PostgreSQL.
• Analyzed source table designed through Aws Schema Conversion tool and Identified data type issues, fixed teh same and created those tables in AWS PostgresQL and Redshift.
• Involved in troubleshoot teh DMS task failures and worked on those tasks.
• Worked on Migrate teh data from On-primase Oracle databases to AWS Aurora PostgreSQL and Redshift.

Environment: AWS(EC2, VPC, ELB, S3, EBS, RDS, Route53, ELB, Cloud Watch, CloudFormation,AWSAuto Scaling, Lambda, Elastic BeanStalk), SQL, AWSCLI,, Shell scripting,Terraform, Postgresql,Oracle10g.12c, SQL server 2008R2,2016

Confidential, Denver -CO

SQL server Database Administrator Consultant

Responsibilities:

• Installed and configured SQL server 2012/2014 wif AlwaysOn 2 replica.
• Working on MS SQL Server 2012/2014 and responsible for installation, configuration and provided 24 X 7 supports to all production Servers.
• Created and migrated partially contained databases wifin AlwaysOn Availability Groups.
• Responsible for Performing SQL server upgrades, conducting performance analytics, and tuning and system sizing and configuration on SQL server version 2012/2014.
• Monitor SQL instances and logs and take corrective actions if problems arise.
• Maintaining teh database consistency wif DBCC at regular intervals.
• Responsible for Identify problematic tables and prepare Implementation plan for cleanup teh tables.
• Created database tables based on SAP MII application functionally.
• Created user defined stored procedures to run multiple transactions in limited duration on SAP MII application.
• Worked on design triggers for automatic executions after user committed transactions.
• Created User defined functions based on SAP MII application requirement.
• Created Views and Synonyms to collect teh sales data for Reporting Purposes.
• Configured SQL JDBC connections between database servers and SAP MII application servers.
• Worked on Import teh application required data to databases from SAP MII application binary file systems.
• Work on database development activities on Development environment and subsequently make changes on Quality and Production environments.
• Worked on ITIL process to implement teh make database changes on each environment (I,e Development, QA and Production environment).
• Work on provide teh SQL database accesses to respective stakeholders and share teh credentials in encrypted format.
• Developed and Rewrote T-SQL queries for better performance.
• Worked on Security issues dealing related to logins, DB users, and application roles and linked Servers.
• Configured teh automatic database maintenance jobs for continuous monitoring.
• Monitor teh database server’s performance through performance counters and SQL Native tools.
• Analyzed long running queries and create teh indexes and recommend for query tuning.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Involved is setting up maintenance jobs related to SQL server health checks and Application health checks.
• Work on query analysis and ensure locking and blocking should not occur during parallel process.
• Analysis teh SQL query execution plan and duration and if any significant changes find teh root cause and resolve teh issue.
• Capture column fragmentations and work on for column defragmentation.
• Develop auto rebuild, re-organize and update statistic maintenance jobs for column defragmentation.
• Actively worked on review and monitor SQL servers and Instance resources to insure continuous database operations (I.e, database storage, memory, CPU, network usage and I/O contention).
• Involved in all Deployment phases (I,e D1,D2A,D2B and D3) to streamline teh plants are in-line wif SAP MII application requirements.
• Work on make changes on SQL database objects (I,e tables, Stored procedures, functions) per application requirements on Development environment and subsequently move to Quality environment.
• Developed and maintained variouscomplex T-SQL, Powershell scriptsfor various DBA related tasks.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Actively worked on test teh required changes on QA environment and move same changes to Production environment.
• Work on establish teh connectivity wif database server and SAP MII application.
• Work on troubleshoot teh production issues and find out teh root cause analysis.
• Perform teh database development activities in tables, stored procedures and functions during cutover and application maintenance window in each deployment phase servers as required.
• Create SQL server instances on SQL server 2014 version and databases wif appropriate initialization parameters and database structures.
• Check for teh database maintenance failed jobs, investigate teh route cause analysis and resolve teh issue.
• Implemented and provided teh design plans for teh new SQL Server 2014 concepts like New In-Memory OLTP Engine, Enhancements to Backups and Buffer pool extension.
• Co-ordinate wif respective stakeholders and SAP MII application team and identify teh records wif respective column key parameters wifin teh respective table (I,e Delta changes) between each Deployment phase.
• Involved in working wif Redgate tool for SQL compare & SQL Data compare between teh databases and tables.
• Compare and Identify delta changes on during each deployment.
• Work on import teh same delta changes on required databases.
• Work on identify and cleanup teh data that not require further after discuss wif SAP MII application team for better performance.
• Work as part of a project team to coordinate database development and determine project scope and limitations.
• Worked on troubleshooting critical performance, space, availability and various issues using TSQL/Powershell.
• Plan coordinate and implement security measures safeguard production and sales order data against to unauthorized users.
• Support to SAP Basis administrator team while configures teh SAP MII application for providing database level input parameters.
• Read teh ERD diagrams and understand on primary key and foreign key relationship and column relationship between teh tables.
• Troubleshoot teh issues on configure teh SAP application wif respective database level.
• Work on Third party application vendors to understand teh application functionality and provide recommendations and feedback to Leadership team.
• Attend troubleshoot calls and resolve teh issues during Hypercare.
• Support responsiveness to outages and issues.
• Collaborates wif developers/application designers in solving critical defects of application before release dates.
• Developed a .bat file to shrink teh log file after successful log backup file job completed on Cummvalut.
• Excellent communication skills, both written and verbal are required for dis position.
• Perform other tasks and duties as assigned by supervisor.
• Monitor teh day to day transactions from Solarwinds DPA and Identify T-SQL long running queries.
• Installed application on AWS EC2 instances and configured teh storage on S3 buckets.
• Amazon IAM was used to maintain teh user credentials and also involved in creating custom IAM policies to various groups defined wifin teh organization.
• Created SQL native backup jobs in AWS IaaS environment servers.
• Scaled distributed in-memory cache environment in teh cloud using Elastic cache.
• Configured and scheduled teh scripts to automate teh module installation in teh environment.

Environment: SQL Server 2005/2008R 2/2012/2016/2017/2019 , T-SQL, Windows Server and SAP Manufacturing Integration and Intelligence, AWS, Cloud Watch, S3, EBS, EC2, RDS, DMS, EC2, Cummvalut, Microsoft Azure and SQL Azure.

Confidential, Cranston- RI

SQL Server Database Administrator

Responsibilities:

• Installation, configuration and upgradation of SQL server 2012, SQL servers 2014 and SQL server 2016 on Windows 2008 and Windows 2012 based on Enterprise Distributed Security (EDS- IBM) standards.
• Installed and configured SQL Server 2016 and higher versions. Configurations built and supported should include scenarios that include leveraging SQL AlwaysOn and Windows failover clustering
• Upgraded/migrated teh several instances and databases from SQL Server 2000 to SQL Server 2005/2008, SQL Server 2005 to SQL Server 2008/2008 R2, from SQL Server 2008/2008R2 to SQL Server 2012/2014.
• Prepared teh documentation and implemented teh Disaster Recovery Plans using Database Mirroring, Log shipping and Replication wif different topologies for production databases.
• Involved Disaster Recovery excise and got CREDO awarded.
• Developed PowerShell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
• Implemented best practices for system and data administration functions for complex, multi-system, multi-platform network on Windows, UNIX and Linux based platforms.
• Migrating teh Database from SQL server 2000 to SQL server2008 and from SQL server 2008 to SQL server 2012/SQL server2014 on SIT/DEV/QA/PRODUCTION region.
• Migrated teh DTS packages from SQL server 2005 DTS to SQL Server 2008 and above into SSIS packages incoordination.
• Configuring of SQL Server 2014 new features like Always On Availability Groups, Contained Databases, Change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE), User-Defined server roles.
• Used multitask data pump in DTS/ETL.
• Assist wif database transaction and security audits.
• Troubleshoot and problem solving of SQL related issues, including advising on customer issues.
• Reviewed T-SQL code and maintaining coding standards in all SQL Server environments.
• Hands on configuring Tempdb wif considerable Memory and Raid Levels for better performance.
• Creating and Maintaining Trace Audits for Security events.
• Involved in teh meetings wif Line of Business for requirements gathering and modified procedures according to teh business requirements.
• Created and used Materialized views and DB links for remote instances to retrieve data from other databases.
• Created and Modified existing functions and procedures based on business requirements.
• Setting up Connection Strings and connecting SQL Server Databases from application front.
• Configured SSIS and SSRS packages on sql server 2014 and moved teh packages and tested them.
• Involved on application migration activities from windows 2003 to windows 2012.
• Designed and built cloud service models including Infrastructure-as-a-Service, Platform-as-a-Service, and Software-as-a-Service on Azure environment as a part of SQL server 2014 and SQL server 2016.
• Provided support on .net\java application migration activities on Windows 2012R2 operating systems.
• Provided 24*7 on call support.

Environment: SQL Server 2005/2008R 2/2012/2014/2016 , T-SQL, Windows Server, HTML 4.0, JavaScript, Access, SQL Query Analyzer, BI Data Tools (SSRS, SSIS, SSAS), DB2, Microsoft Azure and SQL Azure

Confidential

SQL Database Administrator

Responsibilities:

• Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
• Migrated SQL server 2005 databases into SQL server 2008 databases by In-place upgrade and also used upgrade advisor tool for up-gradation.
• Managed teh database objects like Tables, views, indexes.
• Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.
• Worked on moving Data in and out of Windows Azure SQL Databases and Blob Storage.
• Backing up entire user’s database and scheduling backup process.
• Successfully resolved deadlock issues by creating traces objects using SQL Server Profiler.
• Worked on Server Native tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Installed and configured MySQL on Linux and Windows environments.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• MySQL processes and queries optimization. Exported and Imported database 10g objects from development to production.
• Involved in migration and re-engineering of MySQL database from 4.1 to MySQL 5.1.
• Implemented SQL Server high availability solutions includingclustering, Always-on replication, log shipping and Symmetric Remote Data Facility (SRDF).
• Worked inActive/Passive and Active/Active clusterenvironment.
• Responsible for installations, upgrades, patches and fixes.
• ExportandImportof data from text files and Excel to SQL Server database usingBulk Copy InsertandBCP utility
• Setup profiler traces for slow running queries and used query execution plan to optimize teh performance and improve I/O utilization.
• Monitored teh size of teh transaction log. Managed databases on multiple disks using disk mirroring andRAIDtechnology.
• Managed teh products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Created Stored Procedures to transform teh Data and worked extensively in T-SQL for various needs of teh transformations while loading teh data
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
• Tuning Queries and Database performance using tools Database Tuning Advisor and SQL Profiler
• Monitored performance and current space utilization reports to management along wif recommendations for any corrective action.
• Tuning Queries and Database performance using tools Database Tuning Advisor and SQL Profiler
• Monitored performance and current space utilization reports to management along wif recommendations for any corrective action.
• Implemented User-Defined server roles in SQL Server 2012, default schemas for groups.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Implemented Transparent Data Encryption (TDE) to protect sensitive data and backups.
• Developed normalizedLogicalandPhysicaldatabase models to design OLTP system for insurance applications
• Developed PowerShell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
• Implemented SQL Server 2012 new features like AlwaysOn Availability Groups for high availability of multiple databases in place of database mirroring.
• Responsible for migration of databases from one version to other versions and applying patches.
• Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Implement teh New features like Table and Index Partitioning for Larger Tables in SQL Server 2005 for achieving performance enhancement.
• Created logical and physical design of new database to fit new business requirements and implemented new design into SQL Server 2005.
• Actively participated in gathering of User Requirement and System Specification.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.

Environment: Windows Server 2008R2/2012R2, HTML 4.0, JavaScript, Access, Microsoft Azure and SQL Azure. SQL Server 2005/2008/2008 R2/, T-SQL

Confidential

Database Engineer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Directly responsible for teh Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Involved in Data modeling to develop teh database design using Erwin.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Heavily involved in migrating all in houseSQLserver instances & databases toSQLAzurecloud platforms.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts
• Configured SSRS & SSIS for SQL Server 2008 R2, SQL server 2012.
• ImplementedTransactional Replicationfor New Production Environments
• Creating and Troubleshooting SSIS Packages in SQL Server 2012.
• Worked on upgrading DTS to SSIS on SQL server 2012.
• Implemented teh new SQL Server 2008 concepts like Policy Based Management, Central management servers (CMS), Transparent Data Encryption (TDE), Table and Page level compression and Resource Governor.
• Implemented SQL Server 2012 new features like AlwaysOn Availability Groups for high availability of multiple databases in place of database mirroring.
• Implemented and monitored teh replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Implemented and Maintained Log Shipping, Database Clustering, Mirroring, AlwaysOn HADR.
• Has developed TSQL code to setup Multi server Agent jobs to monitor CPU Utilization, Long running Jobs, Failed Jobs, Long running SQL Processes, Number of suspended sessions, Number of active sessions, Blocked sessions, availability group status check, replication monitoring, windows pending reboot, windows SQL Patch check and some other best parameters.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database Links and formatted teh results into reports and kept logs.
• Implemented Replication and Log Shipping to overcome Disaster Recovery plan.
• Suggested Disk Capacity, Processors and Memory based on teh Capacity planning.
• Analyzed database growths for Capacity Planning, Normalized teh data for efficient performance and also Partitioned data into multiple Files and File groups.
• Used SQL Profiler to monitor teh server performance, debug T-SQL and slow running queries.
• Monitored teh application & database performance using SQL Profiler, Performance Monitor.
• Used Index tuning wizard to get a better idea of implementing indexes on teh existing databases and rebuilding only necessary indexes for faster query response.
• Extensively used Database Tuning Advisor to improve teh performance of Query.
• Implemented backup and retention strategies based on business policies.
• Performed Backup/Restore by using VERITAS Net Backup.
• Implemented and maintained SQL Server Agent Jobs, Monitor SQL Server Agent Job history.
• Improved performance of slow running queries using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created SSIS Packages to (ETL) Extract, Transform and Load teh data into Reporting instance to generate teh reports easily and quickly.
• Provided 24/7 critical production support for data issues and given appropriate solutions.

Environment: Windows NT/ 2000/2003/2008 R2,SQL Server 2005/2008/2008 R2/2012,T-SQL,VERITAS.

Confidential

Trainee SQL DBA

Responsibilities:

• Installed SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 wif latest service pack and hot fixes and documented teh same.
• Upgraded and migrated teh servers from SQL Server 2000 to SQL Server 2005/2008.
• Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS packages and resolved issues during migration.
• Migrated Stored Procedures from 2000 to SQL Server 2005 to refer to Dynamic Management Views.
• Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Transactional.
• Implementing Database maintenance plan for Database consistence & Integrity
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs
• Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks.
• Monitoring SQL server performance using profiler to find teh performance and dead locks.
• Creating teh Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
• Implementing high availability using Replication, Log shipping and mirroring technologies
• Set up maintenance tasks such as database backups, consistency checks and Database optimizations.
• Install, Configure and deploy SSIS, SSRS and SSAS.
• Performance tuning, trouble shooting and monitoring using Performance Dashboard reports.
• Database Tuning Advisor, SQL Profiler, Server Side Trace, Dynamic Management views (DMV).
• Day-to-day activities like taking backup (or schedule teh backups daily for database and transaction log) on disk and restore teh databases and transaction log on production/development servers as per requirement.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Directly responsible for teh Extraction, Transformation and Loading of data from Multiple Sources to Data.
• DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Involved in Data modeling to develop teh database design using Erwin.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database Links and formatted teh results into reports and kept logs.
• Provided 24/7 critical production support for data issues and given appropriate solutions.

Environment: .NET Framework 3.5, Visual Studio 2008,C#.net,ASP.Net,Web Services, SQL Server 2005/2008/2008 R2.