SUMMARY

• More than 10 years of IT experience in database administration, server administration and application support.
• ManagedSQL databases for different domains including eLearning, Manufacturing, Insurance and BPO applications.
• Installed, Configured and Maintained databases in SQL Server 2012/2008R2/2008/2005.
• Possess implementation noledge of High Availability (Active - Active\Active-Passive) solutionsfor SQL Server database using Mirroring, Replication, Log Shipping, AlwaysOn and Failover Clustering.
• Implemented SQL database security and managed user logins, server roles, database permissions.
• Extensively used Dynamic Management Views (DMV) to monitor the health of SQL Server instances and identify potential performance issues.
• Possess noledge of configuring and managing various BI Tools such as SSIS, SSRS,and SSAS.
• Possess noledge of database designs by performing needs/requirement analysis, creating logical model tan implementing the physical model.
• Expertise in installing, configuring, patching and upgrading SQL Server software.
• Knowledge of writing T-SQL scripts to perform monitoring and maintenance tasks.
• Created and implemented best practices audit remediation for SQL Server.
• Implemented maintenance solutions for running backups, integrity checks, and index and statistics maintenance on SQL Server 2012/2008R2/2008/2005.
• Expertise in scripting batch jobs and scheduling repetitive maintenance tasks.
• Experience in applying patches, service packs and upgrade.
• Good understanding of hardware and networking technologies.
• Possess good technical and process documentation skills.

PROFESSIONAL EXPERIENCE

Confidential, Wichita, KS

System Admin/DBA

Responsibilities:

• Installed and configured SQL Server databases for third-party applications.
• Migrated Pervasive SQL databases to SQL Server databases of third-party application in coordination wif vendor.
• Acted as point of contact for all third-party applications that are installed in client environment.
• Responsible for capacity planning and documentation of SQL Server database instances.
• Installed, configured and managed vendor applications in the client environment.
• Configured and implemented SQL Server Reporting Services (SSRS)to generate reports against databases.
• Performed impact analysis before changes are made, implement changes, test changes and documented.
• Created, scheduled and managed jobs in SQL Server Agent to perform backups, rebuild indexes and repetitive tasks.
• Created and implemented database security including SQL Server logins, permissions and data encryption.
• Installed, configured and managed Master Data Services for Master Data Management of critical data of client organization.
• Configured server-level and database level audits including DML and DDL activity in SQL Server.
• Responsible for maintenance, upgrade and patch update of vendor applications.
• Implemented session-based desktop deployment (Publish RemoteApp) using Windows 2012 Remote Desktop Services.
• Implemented maintenance solutions for running backups, integrity checks, and index and statistics maintenance on database instances.
• Installed and configured third-party performance monitoring tools (Solarwinds and DBArtisan) for database monitoring and administration.
• Documented SQL Server instances and created run-book to provide operational documentation for the maintenance.

Environment: Windows Server 2012/2008, MS SQL Server 2008/2008 R2/2012

Confidential, Atlanta, GA

Sr. Database Administrator

Responsibilities:

• Installed, configured and maintained database instances in SQL server 2008/2008 R2/2012.
• Extensively used stored procedures to improve query execution and performance.
• Performed needs/requirement analysis for designing databases and data models.
• Managed server alias, protocols and connection parameters through SQL Server Configuration Manager Installation.
• Responsible for user data and log file management to achieve maximum performance, scalability and reliability.
• Implemented ETL process for data extraction, transfer and loading using MSBI tools.
• Scheduled and managed jobs in SQL Server Agent for repetitive tasks such as backups, index maintenance and statistics update in production environment.
• Created complex T-SQL ad-hoc queries for data analysis and data extract.
• Created and implemented extraction methods for data warehouse application databases.
• Performed controlled migrations, upgrades, hotfixes and patch updates on database servers and application servers.
• Responsible for capacity planning of database servers, application servers and clients in VMWare environment.
• Configured and managed production/non-production servers and clients in VMware vSphere 5.
• Monitored database instances using solarwinds database performance analyzer to identify and resolve performance issues related to query optimization, memory, CPU and me/O throughput.
• Advised and implemented High Availability and Disaster Recovery solutions such as Mirroring, Log Shipping, Replication, AlwaysOn and Failover Clustering for critical database instances.

Environment: Windows Server 2003/2008/2008 R2, MS SQL Server 2008/2008 R2/2012, RHEL 4/5.

Confidential

SQL Database Administrator

Responsibilities:

• Extensively used stored procedures for faster execution of queries and creating performance baselines.
• Involved in database design and data modeling by performing needs/requirement analysis, creating logical model tan implementing the physical model.
• Installed, configured and maintained database instances in SQL server 2005/2008/2008 R2/2012.
• Performed controlled migrations, upgrades and patch updates on database servers and application servers.
• Managed server alias, protocols and connection parameters through SQL Server Configuration Manager Installation.
• Responsible for user data and log file management to achieve maximum performance, scalability and reliability.
• Implemented ETL process for data extraction, transfer and loading using MSBI tools.
• Scheduled and managed jobs in SQL Server Agent for repetitive tasks such as backups, index maintenance and statistics update in production environment.
• Created complex T-SQL ad-hoc queries for data analysis and data extract.
• Created and implemented extraction methods for data warehouse application databases.
• Involved in capacity planning for database servers, application servers and clients in VMWare environment.
• Configured and managed production/non-production servers and clients in VMware vSphere 5.
• Monitored database instances using solarwinds database performance analyzer to identify and resolve performance issues related to query optimization, memory, CPU and me/O throughput.
• Advised and implemented High Availability and Disaster Recovery solutions such as Mirroring, Log Shipping, Replication, AlwaysOn and Failover Clustering for critical database instances.

Environment: Windows Server 2003/2008, MS SQL Server 2008/2008 R2.

Confidential

SQL Database Administrator

Responsibilities:

• Installed, configured and managed databases in SQLServer 2005.
• Responsible for up gradation and patch update of database servers and application servers.
• Implemented high availability features such as database mirroring and log shipping.
• Performed Disaster Recovery drills and documented the process.
• Involved in capacity planning for database servers and application servers wif business team.
• Created complex T-SQL queries in data warehouse databases for data analysis and data extraction.
• Configured server alias, protocols and connection parameters through SQL Server Configuration Manager Installation.
• Extensively used DMV’s and DMF’s to identify and resolve performance related issues such as query optimization, memory, CPU pressure, me/O throughput.
• Created and managed DTS packages to transfer excel data into SQL Server database tables.
• Configured and implemented data extraction process for data warehouse databases.
• Created and documented SQL scripts used for daily administration activities.

Environment: Windows Server 2003, MS SQL Server 2005.

Confidential

Jr. Database Administrator

Responsibilities:

• Installed, configured and managed databases in SQLServer 2005.
• Responsible for upgrades and patch updates on database servers and application servers.
• Implemented Active-Passive high availability solutionslike database mirroring and log shipping between production and non-production servers.
• Performed Disaster Recovery drills and documented the process and frequently reported to stakeholders.
• Involved in capacity planning for database and application servers wif business team.
• Created complex T-SQL queries for reporting data analysis and data extraction.
• Extensively used DMV’s and DMF’s to identify and resolve performance related issues such as query optimization, memory, CPU pressure, me/O throughput.
• Created and managed DTS packages to transfer excel data into SQL Server database tables.
• Configured and implemented data extraction methods for populating data warehouse.
• Created maintenance SQL scripts used for daily administration activities.

Environment: Windows Server 2003, MS SQL Server 2005.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, SQL Server Configuration Manager, Database Engine Tuning Advisor, Master Data Services.

RDBMS: SQL Server 2005, 2008, 2008 R2, 2012.

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analytical Services (SSAS)

Scripting Languages: T-SQL and powershell

Operating Systems: Windows Server 2003/2008/2012