SUMMARY:

• Over all 5 + years of Extensive experience with the Microsoft SQL Server in Production, Development and Testing in Clustered and Stand - alone Server Environments.
• Experience in installing MS SQL Server 2005/ 2008/ 2008 R2/2012/2014 \2016 and updating with hot fix and service packs.
• Have immense experience in provisioning user access and wrote many stored procedures related to access provisioning.
• Extensive experience in implementing high availability and Disaster recovery concepts like Log Shipping, Mirroring and Replication (Snap Shot and Transactional).
• Administered multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Implemented (SCOM) System Center Operations Manager to monitor all aspects of SQL Server including.
• Implementing the single Sign on (SSO) enterprise level for internal users.
• Experience in SQL scripts including SPs, PSQL scripting and performance tuning.
• Experience working with scheduling and data modeling tools like Erwin, ER/Studio, SAP Power Designer.
• Deployed SSRS reports in share point for web based access for multiple end users. database performance and health areas including database files, long-running jobs, blocking sessions, compliance and many others.
• Implementing the Cherwell Project ticketing tool for internal users.
• Extensive experience in implementing high availability solutions on physical and virtual machines.
• Had worked on active directory and also have experience in oracle and DB2 database user access provisioning.
• Supported proprietary software utilizing Oracle, Postgres, and Cognos databases.
• Worked closely with development teams to provide perspective.
• Implemented Side-by-Side Migration and in-place Upgrade of MS SQL Server 2005/2008 R 2/2012/2014.
• Experience in using the DMVS, DMFS, SYSTEM VIEWS and in-built Global variables for performance analysis.
• Expert in Data Integrity, Performance Tuning and Query Optimization.
• Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing using T- SQL statements.
• Performed BCP, BULK INSERT, imported and exported data from different Data Sources.
• Experience in Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Experience in analyzing Locks, Dead Locks and handling the Isolation Levels and Concurrency Effects.
• Extensively used the native tools like index tuning wizard, database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor, and Event viewer for performance analysis.
• Experience in Backing up, restoring the database manually and also by scheduling the jobs and Maintenance Plans.
• Implemented scripts to find out the orphan users in the servers and also successfully migrated logins and users between multiple servers. And also creating the audit reports as per the business requirements.
• Configured SMTP Server for Database Mail setup and received alerts for the Threshold values.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Auditing of database for Worked on logins, user permissions and security in SQL server level and fixing orphaned users.
• Experience in SQL Programming, logical and physical data modeling of the database in ERWIN and MSVISIO, Normalization, DE normalization, Database design, Performance analysis and production support for very large (VLDB) in OLTP,OLAP Database.
• Strong experience in mentoring and working with team, coordinating with developers, good communication skills documentation, supporting architects, decision support meetings and 24/7 on call production support.

TECHNICAL SKILLS:

Operating Systems: Windows 2012 R2/2008 R2/2003/2000 Advanced Server, NT & Windows 9x, OEL, RHEL, UNIX, Sun Solaris

Programming: SQL, Unix, C++, FORTRAN, Python

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000

Tools: /Utilities: NetBackup utility, SQL Safe Backups, Idera Diagnostic Monitor, Red Gate,Measurement and Data Analysis of Refractive Index and Optical properties of glasses

PROFESSIONAL EXPERIENCE:

Sr. SQL Server DBA

Confidential,LA

• Installed, configured, administered and secured SQL Server 20012/2014/2016 on production and Non-production in Clustered and Stand -alone Server Environments.
• Implemented Always-ON Availability Groups (AOAG) on SQL Server 2014 SP2. worked in implementing SQL Security and object permissions like maintenance of database creating and users and logins assigning roles to the users and managing user permissions.
• Implemented (SCOM) System Center Operations Manager to monitor all aspects of SQL Server including database performance and health areas including database files, long-running jobs, blocking sessions, compliance and many others.
• Implementing the Cherwell Project ticketing tool for internal users.
• Implemented scripts to find out the orphan users in the servers. Successfully migrated logins and users between multiple servers.
• Administration of PostgreSQL multi node clustered and replicated environments
• Generated audit reports as per the business requirements.
• Extensive experience in implementing high availability and Disaster recovery concepts like Log Shipping, Mirroring and Replication (Snap Shot and Transactional).
• Expert in Data Integrity, Performance Tuning and Query Optimization.
• Loaded multiple NOSQL databases including MongoDB, PostgreSQL, Couchbase, HBase and Cassandra
• Implemented the restores of SQL Azure databases with a clear understanding of the backup retention periods of the Azure databases as per their service tiers.
• Implemented a SQL purging process for Old claim data as per business requirement.
• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, Connectivity issues and Security issues etc.
• Developed and automated daily, weekly and monthly counts of Claims by Scheduling the SQL Job.
• Responsible for ensuring that production SLAs are met, upgrades are delivered without disruption of claims service and monitoring Claims in case of any failures.
• Monitoring the data files, log file space issues, blockings, Tempdb space issues and disk space issues.
• Excellent knowledge in Import / Export using DTS and BCP utility.
• Provided 24/7 support by actively monitoring the job history, alerts.

Environment: SQL Server 2014/2012 with Clustering, Windows 2012 Server, T-SQL, SSRS, Microsoft Azure, Profiler, SQL Server tuning advisor, Putty, TDE (Transparent Data encryption), Always-ON, Failover Cluster Manager, Configuration Management.

Confidential,Torrance, CA

SQL Server DBA

Responsibilities:

• Installed, configured, administered and secured SQL Server 20012/2014 on production and Non-production in Clustered and Stand -alone Server Environments.
• Implemented Always-ON Availability Groups (AAG) on SQL Server 2012 SP2.
• Worked in implementing SQL Security and object permissions like maintenance of database creating and users and logins assigning roles to the users and managing user permissions.
• Implemented scripts to find out the orphan users in the servers. Successfully migrated logins and users between multiple servers. working with Informatic a Power center ETL packages
• Generated audit reports as per the business requirements
• Established DR sites using log-shipping and Wrote dynamic stored procedures for moving Databases from production server to DR server.
• Extensive experience in implementing high availability and Disaster recovery concepts like Log Shipping, Mirroring and Replication (Snap Shot and Transactional).
• Expert in Data Integrity, Performance Tuning and Query Optimization.
• Implemented the restores of SQL Azure databases with a clear understanding of the backup retention periods of the Azure databases as per their service tiers.
• Implemented a SQL purging process for Old claim data as per business requirement.
• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, Connectivity issues and Security issues etc.
• Implemented SQL server security best practices and transparent data encryption (TDE).
• Developed and automated daily, weekly and monthly counts of Claims by Scheduling the SQL Job.
• Responsible for ensuring that production SLAs are met, upgrades are delivered without disruption of claims service and monitoring Claims in case of any failures.
• Monitoring the data files, log file space issues, blockings, Tempdb space issues and disk space issues.
• Applying data fixes into production as necessary, and triaging data-related tickets raised in production.
• Providing monthly metrics regarding database usage and Contributed to Technical Documentation and Run Book updates.
• Actively participated in gathering user requirements and system specifications.
• Analyzed and designed the objects required for the databases.
• Troubleshot the problems and document them.
• Managed Diskspace, memory and User connections.
• Generated Script files of the databases whenever changes were made to stored procedures or views.
• Excellent knowledge in Import / Export using DTS and BCP utility.
• Performed query tuning and reduced response time by 60%.
• Provided 24/7 support by actively monitoring the job history, alerts.

Environment: SQL Server 2014/2012 with Clustering, Windows 2012 Server,, T-SQL, Microsoft Azure, Profiler, SQL Server tuning advisor, Putty,SSRS, TDE(Transparent Data encryption),Always-ON, Failover Cluster Manager, Configuration Management.

Confidential

SQL Server DBA

Responsibilities:

• Managed and administrated SQL Server 2014/2012/2008 R2/2008/2005 on production and non-production servers.
• Installed and configured SQL Server Databases.
• Experience in implementing Always ON Availability Groups in SQL Server 2012.
• Extensive experience in implementing high availability and Disaster recovery concepts like Log Shipping, Mirroring and Replication (Snap Shot and Transactional).
• Setup bidirectional replication and troubleshoot the related issues.
• Experience working with scheduling and data modeling tools Erwin, ER/Studio.
• Developed a SSIS package to load data from SQL Base to SQL Server 2008 R2.
• Performed Failover drill tests to check the High Availability during disasters.
• Day-to-day activities like taking backups, restoring the databases, custom code deployment.
• Supported technical teams involved with MS SQL issues and operations.
• Implemented and maintained Database Mirroring, Log shipping and Transactional Replication as Disaster Recovery/High Availability solution.
• Managed and administrated SQL Server 2012/2008R2/2008 on production and non-production servers.
• Worked on logins, user permissions and security in SQL server level.
• Monitored SQL Server Databases using DMV’s, DMF’s as wells as monitors tools like Idera Diagnostic Monitor.
• Performed data migration and schema migration between different environments.
• Performed various data transfers between various servers using BCP and Import/Export wizard.
• Implemented Policy Based Management on the servers.
• Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2008
• Used Lite Speed for backups and maintenance jobs which includesupdating statistics, database integrity checks.
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics.
• Involved in Database design, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database. Created SQL tables using scripts and Erwin Forward Engineering Utility.
• Modified Stored Procedures and complex T-SQL queries to improve query execution process
• Used SQLDiag utility tool for troubleshooting some issues.
• Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans.

Environment:: SQL Server 2008/2012/2014, Windows Enterprise Server 2008, Microsoft Reporting Service, Excel, Crystal reports, SQL Enterprise Manager .