SUMMARY:

• Having Extensive years of Database Administration and Development experience on MS SQL Server 2017/2016/2014/2012/2008 R2/2008/2005/2000 in Very Large Data bases.
• Experience in Migrating SQL servers from 2005 to 2008R2 and 2008R2 to 2016.
• Experience working with Golden gate for SQL and ORACLE.
• Experience in Migrating Databases from One Datacenter to Other.
• Experience Migrating databases from on Premise to Azure, Aws.
• Migrated from a SQL2008 virtualized Platform to a highly automated, virtualized SQL2012 - 14 Hybrid Cloud Platform utilizing the latest compute and storage technology to offer maximum performance, availability and security.
• Managed databases sizes ranging from 500GB to 3 TB
• Experience and Knowledge on HA/DR like Always On, Replication/log shipping/clustering.
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Experience working in storage migration and helping sysadmins,
• Thorough knowledge on SAN environments, RAID levels, VMware Environments.
• Thorough understanding of blocking/lock issues, Tempdb Optimization, File group management.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database Confidential, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, SQLCMD.
• Querying the databases using the PowerShell scripts.
• Good experience in resolving SQL Server blocking and Dead Lock Issues.
• Good Understanding of Virtual Private Networks.
• Hands On experience on GRC ARCHER.
• Designed and implemented Class level DHCP and basic Knowledge in cryptography.
• Well Experienced in Performance Tuning (System level/Database Level/Query Level) and optimization.
• Upgraded databases from MS SQL Server 2008 to MS SQL Server 2012/2014, MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2000 to MS SQL Server 2005.
• Expert in extracting from different sources, transforming and loading data using transformation services like data transformation services like Batch processes, Import/Export, SSIS, DTS, BCP and Bulk Insert.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc for finding out long running queries.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.
• Experience in creating documentation for all the DBA activities.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Implemented Confidential Replication as a part of DR solution.
• Implemented Latest Features like Data Compression and Backup compression reducing I/O and Transparent Data Encryption for encryption in SQL 2008 R2.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc depends on scenarios.
• Created effective Backup and Recovery plans based on RPO.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database Confidential, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, SQLCMD.
• Experience in working with Agile/SCRUM based product development teams, collect database requirements and provide solutions and recommendations for new schema, infrastructure or architecture.
• Perform other regular DBA activities including space management and performance monitoring.
• Expert Level skills in providing 24x7 DBA Level 3 support in Production, QA and Development.

TECHNICAL SKILLS:

Databases: Oracle, SQL Server

Tools: MS SQL Server 2014/2012/2008 R2/2008/2005/2000, MS Office, Access 97/2000/2003.

Operating System: Windows NT/2003/2008R2/2012/2104, Linux, UNIX, T-SQL, XML, PowerShell

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

SQL SERVER DBA

• Manage and administer over 100 instances of SQL server 2005/2008R2/2012/2014/2016 servers.
• Migrations of databases from SQL 2008R2 to SQL 2016.
• Migration of SSRS reports from legacy environment to our new data center.
• Developed many SSIS packages to schedule jobs, Created reports with SSRS.
• Created store procedures, functions, T- SQL scripts.
• Provided High availability through Clustering (Active/Active and Active/Passive), Mirroring, Replication ( Confidential ).
• Deployment of databases, jobs from pre-production to production.
• Building SQL 2005/2008/2012/2014/2016 cluster environments on VMware or Physical windows
• Performed installations of SQL 2005/2008/2012/2014 on clustered and standalone servers
• Upgradations of sql server versions and applying patches and hot fixes.
• Adding nodes to already existing clustered servers as a part of data load\High availability
• Configured Confidential Replication and Log Shipping with SQL Server Management
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Work on weekly Issues reports which are generated as a part of infrastructure setup.
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Used the PowerShell scripting to get the most consistent production environment.
• Documenting the standard procedures on regular basis.
• Worked in a environment with Change management process (Service-now tool) for all kind of production and non-production changes
• Involved in all ITIL process like Change management, Incident Management & Problem Management.
• 24/7 on call production support.

Environment: MS SQL Server2016/2014/2012/2008/2005, SSIS, SSRS, Windows 2014/2012/2008/2003, Excel, Redgate, SQLDM

Confidential

SQL Server DBA

• Migrations of databases from SQL 2008R2 to SQL 2016.
• Worked on different security issues to remove individua logins and requesting the developers to move towards AD groups.
• Created store procedures, functions, T- SQL scripts.
• Deployment of databases, jobs from pre-production to production.
• Building SQL 2005/2008/2012/2014/2016 cluster environments on VMware or Physical windows
• Upgradations of sql server versions and applying patches and hot fixes.
• Configured Confidential Replication and Log Shipping with SQL Server Management
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Work on weekly Issues reports which are generated as a part of infrastructure setup.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Working on tickets\incidents with in the SLA’s, as a part of operations support DBA
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
• Resource planning and coordination for application migrations with project managers, application and web app teams
• Involved in capacity planning, sizing and database growth.
• 24/7 on call production support.

Environment:MS SQL Server2016/2014/2012/2008/2005, SSIS, SSRS, Windows 2014/2012/2008/2003.

Confidential, Charlotte, NC

Database Administrator

• Manage and administer SQL server 2005/2008R2/2012/2014 servers.
• Managed over 400+ servers and 1000+ databases which include Dev, QA and production.
• Supported over 160+ production server in GWB line of business
• Managing very large databases over 3TB .
• Setup replication between Oracle and SQL server using GOLDEN GATE.
• Responsible for supporting ultra-critical applications of the bank.
• Achieved RPO and RTO for most of the UCAL applications.
• Implemented Backup and recovery solutions including point in recovery.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Performed patches for SQL 2012/2014 on clustered and standalone servers
• Created the backup and restore strategy for production and development environment.
• Upgradations of sql server versions and applying patches and hot fixes.
• Setup Database mirroring for SQL SERVER for DR scenario
• Configured Confidential Replication and Log Shipping with SQL Server Management
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Work on weekly Issues reports which are generated as a part of infrastructure setup.
• Continuous monitoring server health with Foglight monitoring tool.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans
• Working on Tempdb issues and helping developers to optimize their queries.
• User management and providing Sox report access security model to app managers.
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Used the PowerShell scripting to get the most consistent production environment.
• Documenting the standard procedures on regular basis.
• Working on tickets\incidents with in the SLA’s, as a part of operations support DBA
• Involved in capacity planning, sizing and database growth.
• Worked in a environment with Change management process (Service-now tool) for all kind of production and non-production changes
• Involved in all ITIL process like Change management, Incident Management & Problem Management.
• 24/7 on call production support.

Environment: MSSQL Server 2014/2012/2008/2005, Windows 2005/2008/2012, Oracle Golden Gate, oracle 12C, Nexus, ITSM, HPDMA, Blade logic, Avaamar, ARM, BMC Remedy

Confidential, Lake Forest, IL

Database Administrator

• Installed and configured SQL Server 2012 Enterprise edition in the Production/QA environment.
• Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012/2014.
• Provided High availability through Clustering (Active/Active and Active/Passive), Mirroring, Replication ( Confidential ), and Always On.
• Performed installations of SQL 2005/2008/2012/2014 on clustered and standalone servers.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing and Contained Databases.
• Worked with Rman backups and impdb and EXPDP
• Adding nodes to already existing clustered servers as a part of data load\High availability.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Managed Production environment for High Availability in Active/Active and Active/Passive mode
• Worked on setting up and managing Confidential and Confidential Replication
• Involved in Monitoring Performance of different production servers.
• Implemented Database mirroring and Log shipping for disaster recovery.
• Maintained various databases for Production and Testing using SQL Server 2014/2012 R2.
• Planning the location of data, index and Transaction log files on the disk.
• Performance tuning and optimization of procedures and queries.
• extensive use of SQL Server DMV's for Performance Tuning
• Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics, Re-indexing and online Indexes.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application.
• Migrated MS SQL Server 2008 to MS SQL Server 2012

Environment: MS SQL Server 2000/2005/2008/2012\2014, Windows 2003/2008, SSRS, SSIS, SSAS, PowerShell script, Erwin, companion, Idera, TSM/TDP,oracle 11g/12c.

Confidential, Union, NJ

SQL Server DBA

• Manage and administer SQL server 2005/2008R2/2012/2014 servers.
• Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012/2014.
• Configured ALWAYS ON setup between different DATA Centers and on Multi Subnet Cluster.
• Configured Windows Failover Clustering and SQL Clustering on Multi Subnet Cluster.
• Deployment of databases, jobs, cubes from pre-production to production.
• Building SQL 2005/2008/2012/2014 cluster environments on VMware or Physical windows
• Performed installations of SQL 2005/2008/2012/2014 on clustered and standalone servers
• Upgradations of sql server versions and applying patches and hot fixes.
• Adding nodes to already existing clustered servers as a part of data load\High availability
• Configured Confidential Replication and Log Shipping with SQL Server Management
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Used the PowerShell scripting to get the most consistent production environment.
• Experience on working with File Maker Pro.
• Documenting the standard procedures on regular basis.
• Working on tickets\incidents with in the SLA’s, as a part of operations support DBA
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
• Resource planning and coordination for application migrations with project managers, application and web app teams
• Involved in capacity planning, sizing and database growth.
• Worked in a environment with Change management process (Service-now tool) for all kind of production and non-production changes
• Involved in all ITIL process like Change management, Incident Management & Problem Management.
• 24/7 on call production support.

Environment: MS SQL Server 2008/2005, .NET Framework, DTS, SSIS, SSRS, SVN, C# .NET, SSL, IIS 6.0/7.0, Windows 2008/2003, Erwin, Excel.

SQL DBA

Confidential, Atlanta, GA

• Database Administrator, Database Programming.
• Responsible for Logical & Physical Database Design.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Creation of New NT Logins and granting privileges to users/Groups and objects.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes.
• Backup and recovery of Master, MSDB and Application databases.
• Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current.
• Implemented log shipping and performed changing roles when production data base goes down.
• Worked extensively on DTS Package designs for Import/Export from various Data Source Flat file, Excel, MS Access to MS SQL Server and schedule the jobs in SQL Server.
• Provide 24x7 dedicated support to all Production, QA & Development MS SQL Server Environments.
• Related issues /performance related issues with Minimal Downtime & Maximum Reliability.
• Responsible for deployment from development to test, UAT and production environments.
• Review / test / apply all database changes to all environments including developments and Production Servers. Monitor SQL Error Logs /Schedule.

Environment: MS SQL Server 2008/2005, .NET Framework, DTS, SSIS, SSRS, Windows 2008/2003, Erwin, Excel