SUMMARY:

• Database Management | System Administration | Data Architecture | Data Modeling | Database Design | Troubleshooting
• Change Management | Project Management | Technical Documentation | Excellent Communication |Technical Support
• MS certified SQL Server administrator offering 10+ years of experience in administration and development of SQL databases.
• Extensive operational background in installing/maintaining/patching SQL Server instances.
• Experience in Amazon Web Services with both EC2 and RDS platforms and also with Azure SQL databases.
• Expertise in creating backup and restore strategies for very large databases as per the needs and requirements of businesses.
• Worked extensively on point - in-time database restores, minimizing the downtime and loss of data.
• Experienced in working with data warehouses of sizes more than 10 TB. Solid understanding of database recovery models.
• Proficient in server upgrades, upgrading to SQL Server 2019/2017/2016 from 2014/2012/2008 R2.
• Experienced in creating, maintaining, and automating SQL Server Agent jobs.
• Created Maintenance Plans involving backups, index maintenance, database health checks and cleanups of older files.
• Highly experienced in configuration of Database Mail, Operators and Notifications.
• High level of expertise in Security Management, implemented server, database, object and job level security.
• Experienced in migration of databases from one server to another.
• Experienced in resolving Log space issues, tempDB issues, memory issues and Database allocation, consistency errors.
• Highly experienced in High Availability (HA) and Disaster Recovery (DR) technologies.
• Successfully implemented Transactional, Merge, Peer to Peer and Snapshot Replication.
• Successfully implemented Transparent Data Encryption (TDE) on production databases.
• Proficient in implementing Log Shipping and Database Mirroring.
• Implemented Always on Availability Groups (AAG) and SQL clustering.
• Created Linked Servers between MS SQL and ORACLE, MS SQL and AS400 databases.
• Solid experience in Performance Tuning. Expertise in implementing partitioning of tables and Full Text Search.
• Experienced in creating Indexes to improve performance and maintaining them. Expertise in Statistics maintenance.
• Monitored performance issues using SQL DMVs and Perf Mon tools to identify resource bottlenecks.
• Proficient with third party tools like Red Gate SQL Monitor, Idera SQL Diagnostic Manager and Quest Spotlight.
• Proficient in HA/DR solutions including Always On. Good experience with PowerShell scripting.
• Excellent skills in Database Design, Modelling and Analysis. Solid T-SQL programming skills in SPs, Functions, Views.
• Knowledge of various BI technologies - SSIS, SSRS, SSAS, Qlik sense, google analytics (workspace, sheets, data studio).
• Experienced in third party apps such as TIBCO, Microsoft Dynamics, SharePoint, Citrix.
• Experienced in handling Very Large Databases (VLDB) and providing 24 x 7 production on call support.
• Experienced in Software Upgrades, Database Conversions, documentation and effective communication with the management.

TECHNICAL SKILLS:

Databases: MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008R2, 2008, ORACLE 12C, 11G, MySQL, TeraData

Programming: C# (.NET Platform), T-SQL, PL-SQL, Python, PowerShell 4/3

Cloud Computing: Amazon Web Services, Microsoft Azure

DBA: Database administration of MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008R2, 2008

Operating System: Windows 2016/2012/2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools: Backup Utility, SQL Lite Speed, Visio, SQL Sentry, Idera, Red Gate, JIRA, Remedy

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Administrator

Responsibilities:

• Administering 70 servers and 1600 databases including dev, test, stage and production environments.
• IT SME for all SQL server related questions, act as a single point of contact for developers/users/management for SQL.
• Installing/patching SQL Servers. Perform a POC on any new version/feature to be implemented in the organization.
• Upgraded SQL Servers from SQL 2012 to SQL 2017. Doing a POC for SQL 2019.
• Implemented Always-ON in the organization. Designed and administering a node synchronous/asynchronous cluster.
• Implemented Database mirroring and Log Shipping as a HA and DR solution.
• Created and monitored the database maintenance tasks using Azure Automation.
• Experience in working with Point in time restores in Azure.
• Refresh Tables/Databases in lower environments on developer’s request.
• Maintain security and make sure that principal of least privileges is applied.
• Implemented real-time I/O encryption and decryption of data and log files - Transparent Data Encryption (TDE)
• Work with Microsoft/other vendors to get support if and when needed.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Oral and written communications with business stakeholders to gather business requirements and perform data delivery.
• Install, maintain, monitor and performance tune test, development, stage and production SQL Servers and databases.
• Design the backup strategies for different servers. Install and create backups of databases using Litespeed backup tool.
• Design the HA solutions for databases including AAGs, SQL clustering, Log shipping and database mirroring.
• Make sure the SLAs, RPOs and RTOs are being met for the business and 99% of up time is maintained for the databases.
• Use of different data analytics tools to create datasets which helps power users to gain business insights.
• Work with outside vendors/partners and different application teams to fulfill their database needs. (Database refreshes/procedures/tuning/space requirements.)
• Environment:SQL Server 2019/2017/2016/2012/2008 R2/2008, .Net Framework 4.6.2/4.6.1/4, C#.Net, Windows 2016/2012R 2/2012/2008/2003 Server, VMware 12, 11, MS -Azure Instances, Azure SQL DbsSpotlight Monitoring, Litespeed 7.4

Confidential

Senior Database Administrator

Responsibilities:

• Drive the design, development, implementation and expansion of databases utilizing the full MS SQL Server Stack.
• Work as a team player with the product, application development, and infrastructure teams to gather data and reporting requirements and formulate solutions to service them efficiently.
• Worked with application teams and external vendors to install, configure and maintain database servers.
• Test performance of databases to ensure they are efficient, scalable and tune queries, to achieve desired system performance.
• Created stored procedures and functions. Deployed and maintained SSIS packages.
• Implemented transparent data encryption on production databases on SQL2017 and 2016.
• Side by Side migration of SQL servers from VMs to NGDI cloud environments and Azure instances.
• Managed 4 Virtual Machines in IAAS and 200 databases on PAAS, supporting max size of 4 TB hosted in Microsoft Azure.
• Configured on-premises SQL database backups to Azure using Microsoft Azure Backup tool.
• Helped improve the performance of queries by creating indexes and helping the users write queries.
• Helped improving the overall performance of the server by analyzing databases and suggesting indexes, updating stats.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Configured Always-On with synchronous and asynchronous secondary replicas.
• Configured Transactional replication from multiple publishers to one subscriber.
• Creating and Maintaining Database Maintenance Plans.
• Performed database refreshes from production to non-production environments.
• Keeping the Databases up to date -- includes the regular patching, upgrade and support activities which are required to keep the database secure.
• Supporting activities that include on call (24/7) monitoring of the critical production databases and taking steps to provide business continuity.
• Supporting development community. This includes database design as well as code reviews, contributing to the knowledge base of the software engineers about SQL Server database features, tuning expertise and providing implementation support as required.
• Supporting the enterprise development objectives, this includes deployment of the database artifacts and researching the impact and enabling any database feature that would be required for the enterprise applications.
• Environment:SQL Server 2017/2016/ 2014/2012/2008 R2, SSRS, SSIS, .Net Framework 4.6.2/4.6.1/4 .6/4.5, C#.Net, Windows 2016/2012R 2/2012/2008/2003 Server, VMware 12, 11, Red Gate monitoring, EMC Avamar 7.5, 7.4, 7.2. Amazon Web Services EC2 Instances and RDS, Microsoft Azure Instance, NGDI cloud instance.

Confidential

SQL Server DBA

Responsibilities:

• Production office DBA with 400 servers and 1400 databases. Handled databases ranging from 6TB to 12TBs
• Worked with application teams and external vendors to install, configure and maintain database servers.
• Created stored procedures and functions. Deployed and maintained SSIS packages.
• Helped improve the performance of queries by creating indexes and helping the users write queries.
• Helped improving the overall performance of the server by analyzing databases and suggesting indexes, updating stats.
• Upgrades ofSQLserver 2008/2008R2 to 2012/2014/2016 and apply Service packs wherever needed.
• Configured Always-On with synchronous and asynchronous secondary replicas.
• Configured Snapshot replication for load balancing.Creating and Maintaining Database Maintenance Plans.
• Migrated on premise databases to Microsoft Azure - IAAS and PAAS. Around 4 environments in cloud with POC in AWS.
• Experience in creating the database maintenance tasks using Azure Automation.
• Implemented multiple levels of security. Secured critical databases with TDE.
• Modified complex stored procedures and complex queries to better the performance.
• Write T-SQLScripts for database backup jobs and daily/weekly jobs.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Optimized the database server using DMV's and DMF's and performed a code review and tuning for the best performance.
• Formulated custom reports via SQL server Reporting tools.
• Implemented improvement procedures on Microsoft SCOM based systems. 24* 7 on-call production support.
• Environment:SQL Server 2016/ 2014/2012/2008 R2, Oracle 10g/ 9i, .Net Framework 4.6.2/4.6.1/4 .6/4.5, C#.Net, Windows 2016/2012R 2/2012/2008/2003 Server, Microsoft Azure/Amazon AWS, Foglight Monitoring, Avamar 7.4, 7.2.

Confidential

Senior Database Engineer

Responsibilities:

• Installation and maintenance of SQL Server 2016/ 2014/2012/2008 R2 on production and non-production environments.
• Implemented Transactional Replication. Configured Always-On with synchronous and asynchronous secondary replicas.
• Administered over 150 servers and 600 databases. Provided technical expertise to the power users and other business users.
• Administered access to SQL servers and making sure principal of least privileges is maintained.
• Monitored servers using Dell’s Foglight monitoring tool. Handling backups using EMC’s Avamar backup tool.
• Upgrades ofSQLserver 2008/2008R2 to 2012/2014/2016 and apply Service packs wherever needed.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Configured SQL Server Clustering.Configured Always-On with synchronous and asynchronous secondary replicas.
• Creating and Maintaining Database Maintenance Plans.Performed database refreshes from production to non-production environments.
• Configured Database Mail for failure Job notifications.
• Modified procedures and complex queries to better the performance. Write T-SQLScripts for database backup jobs and daily/weekly jobs.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• 24* 7 on-call production support.
• Environment:SQL Server 2016/ 2014/2012/2008 R2, Oracle 10g/ 9i, .Net Framework 4.6.2/4.6.1/4 .6/4.5, C#.Net, Windows 2016/2012R 2/2012/2008/2003 Server, VMware 12, 11, Foglight Monitoring, Avamar 7.4, 7.2.

Confidential

Database Engineer

Responsibilities:

• Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment. Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).
• Environment:SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Visio, SFTP

Confidential

Database Specialist (Contract & Full Time Employee)

Responsibilities:

• Database Administrator, Database Programming.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policy
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database.
• Troubleshoot performance problems and fine-tuning of databases.
• Migrating SQL Server 2005 data bases into SQL Server 2008R2/2012.
• Recovering the databases from backup in disasters.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Environment:SQL Server 2012/2008R2/2005, Windows 2008/2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request