SUMMARY

• Accomplished SQL Server DBA with 12+ years of experience in managing databases and server. Effectively plan, install, configure and optimize the IT infrastructure to consistently achieve high availability and performance. Capable of managing huge SQL database with data query skills having end to end requirement capture and database system design. Innovative and creative, problem solver, who is results oriented, has an aptitude for learning and can maximize resources.
• I have ability to handle Incident escalation and demonstrated skillset with trending observations on system and application failures/bottlenecks and recommending approaches for resolving and proactively preventing them. I have experience with team resource planning and skill deployment.
• Proven ability to create and deliver solutions tied to business growth, organizational development and systems/database optimization. Skilled problem identifier and troubleshooter comfortable managing systems, projects and teams in a range of IT environments.

TECHNICAL SKILLS

SQL Server: MS SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014 and 2016

SQL ETL and Reporting : Sql Server reporting and Integration services (SSRS and SSIS)

SQL Tools: MS SCOM 2007, SQLDIAG, PSSDIAG, SQLNEXUS, SQL Profiler, DTA

THIRD PARTY SQL Tools: CA XASOFT, SQL REDGATE Backup, SCALE ARC

ERP : PeopleSoft 8.4 and 9

Virtualization Tool : VMWare 5.0,CITRIX

Release Management Tool : Team Foundation server, GitHub, Azure Dev Ops (ADO), GitHub

Window administration: 2003, 2008, 2008 R2, 2012, 2016

Azure : Windows Azure & SQL Azure

Dev Ops : Azure DevOps, Urban Code Deploy, Jenkin

Monitoring Tool : Hostmon, PerfMon, SCOM, SCCM, Precise

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server Database Administrator

Responsibilities:

• Experience of managing multiple MS SQL 2000, 2005, 2008, 2008 R2, 2012 and 2016
• Migrate to Azure SQL Database or provision a new SQL database on Azure
• Backup and restore Azure SQL Databases. Monitor and optimize the performance of cloud database
• Automate database deployment process using Azure DevOps, Urban Code Deploy and Jenkin
• Design SQL Server 2016/2012/2008 database solution as per the application requirements. Determine database environment setup for applications from development through production implementation
• Design DR strategy as per the database/application need. Perform backup and recovery, implement and validate backup strategy. Make sure backups have been successfully stored to a secure location
• Design/implement High availability techniques like clustering, replication, log shipping on production and non - production environment
• Design and install SQL server environment for Shared/dedicated database requirement and setup cluster. Install/Configure/upgrade SQL Server on standalone/cluster environment using organization standards
• Design and implement Transparent data encryption (TDE) solution on new database. Implement Transparent Data Encryption on existing databases which enable extra security on database file level
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. Configure and maintain database servers and processes including monitoring of system health and performance to ensure high levels of performance, availability, and security
• Perform the capacity planning for the databases and monitor disk space to avoid disk space outage. Submit the storage expansion request as required
• Perform database migration from SQL Server 2008 End of Service Life (EOSL) system to SQL Server 2016
• Check and verify scheduled SQL jobs execution and make sure jobs are completing successfully
• Ensure the security of each SQL Server/database and follow the company security standards
• Manage the SQL database inventory and ensure that inventory is updated,
• Create/Update SQL server runbook
• Perform audit on job execution time for long running jobs against baseline runtimes
• Work with application teams and suggest best practices on their SQL code/queries

Confidential

Database Admin Associate Manager

Responsibilities:

• Experience of managing multiple MS SQL 2000, 2005, 2008, 2008 R2, 2012 and 2014
• Experience on High availability techniques like Always ON, clustering, replication, log shipping or mirroring
• Always On implemetntation on production environment
• Design, test and implement Resource Governor to control customer applications that dominate SQL Server resources
• Cluster setup and SQL installation on cluster environment
• SQL Installation, Configuration & Upgrading
• SQL Server, Database monitoring using DMVs
• Encrypted data and log files using transparent data encryption (TDE) solution on new database
• Implemented Transparent Data Encryption on existing databases which enable extra security on database file level.
• Transparent Data Encryption implemation on AlwaysoOn Group
• Basic network administration
• Window server and VMWare administration, Basic network configuration for VMs and servers
• Production support (24*7)
• Security Solutions
• System Patches & Updates
• Training & Mentoring
• Writing PL/SQL quries for SSRS report
• Deployment of PL/SQL Code to different environment
• View creation for SSRS report
• Oracle client installation on Server as well as Desktops
• Running health check with Health Monitor
• Database backup using OEM

Confidential

Sr SQL DBA

Responsibilities:

• Create/Drive/Resolve Problem Tickets & VSTF items
• Regularly monitor and automate/suggest monitoring where possible/needed
• Regularly collect/report and analyze KPI data
• Perform regular database Maintenance and operations tasks using common practices and improve/automate the processes
• Worked as Sr. SQL-DBA on Production Environment