SUMMARY

• A certified SQL Server DBA wif 12+ years of experience in Database Administration, Design & Implementation, Development and Support of MS SQL Server 2016/2012/2008 R2/2005 in Production, UAT and Development Environments.
• Experience in Performance Tuning, Index Tuning, Execution Plan, Query Optimization, Statistical methods, Access time, and Device allocation, Reports, Backup and Disaster Recovery.
• Solid expertise on SQL Server high availability solutions, including Always - On Availability Groups, and SQL Server Clustering (Active-Active, Active-Passive).
• Proficient in SQL/T-SQL, indexes, stored procedures, triggers and functions.
• Proven ability to identify root cause of database issues wif expertise to troubleshoot and resolve issues promptly.
• Hold exclusive noledge of database security including data encryption and decryption.
• Working noledge of SQL server upgrades and migrate using various versions and editions.
• Database Administration (MS SQL 2005, 2008, 2008R2, 2012, 2014, 2016, 2017 & 2019).
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Expert in handling tight planned/unplanned outage windows
• Proven track record in planning and building high performance support systems, implementing best practices/methodologies and continuous improvement programs that resulted in improved quality of operations and service levels.
• Experience in Supporting Microsoft Azure Database infrastructure.
• Experience in handling AWS RDS like Cassandra, Postgres, MSSQL Databases.
• Experience in Database backup and disaster recovery procedures.
• Experience in Log Shipping, Replication - Snapshot and Transactional.
• Knowledge of SQL Server Clustering, Analysis Services & Reporting Services.
• Experience in MS SQL Server upgrades from SQL Server databases.
• Experience in SSIS & SSRS (2005, 2008, 2012 & 2014)
• Experience in PowerShell scripting.
• Strong noledge of teh Software Development Life Cycle (SDLC), Change Management (CM) process, and ITIL-based methodology.
• Applied Service Packs and hot fixes.
• Delivers high quality work and performs well under pressure.
• Works under minimal supervision and has ability to prioritize own workload, and has worked on complex large-scale projects, requiring interacting wif people of various technologies.
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Experience in providing Capacity planning reports to teh management.
• Expertise in Managing Virtual Environments Hyper-V and VMWare.
• Experience in Storage Administration EMC VNX, VPlex and HP 3Par.
• Created complex DTS Packages for Data Migration and Transformation, experience in data migration from oracle /excel to SQL Server 2000/2005/2008.
• Expert in regular Database Maintenance - Disk Space Monitoring, Backup and Recovery, Database Tuning.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions. Very good T-SQL Programming skills.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Has teh ability to work in a fast paced environment, Good team player.

TECHNICAL SKILLS

RDBMS: MS SQL 2005, 2008, 2008 R2, 2012, 2014 & 2016.

Hypervisor: Hyper-V, VMWare.

Storage: EMC VNX & VPlex, HP 3Par

Backup Tools: Symantec NetBackup, HP Data Protector.

Programming/Scripting: SQL,PL/SQL, Unix Shell

OS Environments: Windows 2003, 2008, 2012 & Red Hat Linux 4.5.

Hardware: IBM, HP, Dell, EMC & Compatibles.

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Administrator

Environment: Microsoft SQL Server 2005, 2008, 2008R2, 2012, 2014 & 2016 Hyper-V, VMWare, EMC VNX 5800, EMC Vplex, Symantec Netbackup

Responsibilities:

• Handling Clients Production Databases and maintaining High Availability like AlwaysOn AG, replication, mirroring and logshipping.
• Install configure and maintain AlwaysOn AG cluster wif single primary and multiple secondary nodes in teh same Datacenter and Distributed AG across different datacenters.
• Design, implement & maintain objects Replication (transactional & snapshot) to maintain data consistency across teh nodes depending upon teh requirement.
• SQL standalone/Cluster Installations.
• Migrated Databases from on-prem MSSQL Server to Cassandra and Postgres.
• Manage and support AWS RDS instances like Cassandra, Postgres, MSSQL.
• Performing Database maintenance activities like Backups, Restoring, and Re-indexing etc.
• Managed all phases of teh software development lifecycle (SDLC).
• Creating Maintenance plans and jobs for automation of teh repetitive task & Monitoring teh Scheduled jobs
• Analyzing, Identifying and Resolving performance issues of teh server
• Configuration and troubleshooting of high availability and disaster recovery features like log shipping, mirroring, replication, clustering etc.
• Analyzing and troubleshooting teh SQL Server processes and jobs
• Manage day-to-day SQL Server Administration wif PowerShell
• Maintain teh SQL Server environment using PowerShell scripting and programming options.
• Experience indeveloping,monitoring, extractingandtransformingdata usingDTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided bySSISsuch asData Conversion,Conditional Split,Bulk Insert,Mergeandunion all.
• Developing reports onSSRSon SQL Server (2005/2008/2012 ). Sound Experience and understanding ofSSAS, OLAP cube and Architecture.
• Solving Disk space, Log files full and database file full related issues on SQL servers.
• Proactively working on Performance and Blocking issues on servers by auditing Databases.
• Installations, patching, cumulative upgrades, hot fixing, backing up and recovering high impacting databases, monitoring and administration of jobs. Installations are made on both stand-alone as well as clusters
• Replication Set up end to end
• Work as part of a team and provide 7×24 supports when required.
• Managing Virtual Environments Hyper-V and VMWare.
• Managing and supporting Production, Development & TEST environments.
• Setup and maintain documentation and standards.
• Developed SQL scripts for maintaining administration tasks.
• Allocating system storage and planning future storage requirements for teh database system for all teh clients
• Created and maintained users and user groups.
• Installing and upgrading teh database server and application tools
• Work as part of a team and provide 7×24 supports when required.

Confidential

Senior Database Administrator

Environment: Microsoft SQL Server 2005, 2008, 2012 & 2014 Windows 2008,2012 Server, NetApp, Hyper-V, Oracle VM, HP Dataprotector

Responsibilities:

• Involved in installation and configuration of SQL server 2005, 2008 and 2012.
• Applied patches and service packs to keep teh database at current patch level.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Managing and supporting Production, Development & TEST environments.
• Database High Availability: Installed, Configured and Managed Database Mirroring, Replication, AlwaysOn and Fail-Over Cluster Servers in SQL Server 2012.
• Migrated MSSQL Databases from in premises to MS Azure Cloud.
• Configured bulk import jobs using powershell.
• Automated routine/repetitive jobs using powershell.
• Configured bi-directional transactional replication to maintain consistent data across teh clusters.
• Regular Database Maintenance jobs
• Disk Space Monitoring & Administration
• Performance Monitoring & Administration
• Performing Backups and testing Recovery scenarios etc.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
• Supported production and development databases.
• Implemented SQL standards in writing Stored procedures, Triggers, Views, Sql functions and locking issues.
• Coordinated physical changes and performance monitoring of two replicated production servers, all Microsoft SQL Server 2005.
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
• Developed SQL scripts for maintaining administration tasks.
• Applying Cumulative, Mini, Bug Patches & Performing Upgrades.
• Created and maintained users and user groups.
• Backup and Recovery plans for Field office and Headquarters database servers.
• Maintained teh field office database backups through SQL mail Scripts.
• Interacting wif teh users and troubleshooting teh problems involved wif teh development of stored procedures.
• Responsible for General Database Administration and Performance tuning.
• Experienced in resolving deadlock and blocking issues for concurrent users.
• Developed Database Backup Scripts and automated this process.
• Applied patches and service packs to keep teh database at current patch level.
• Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
• Implemented SQL standards in writing stored procedures, Triggers, Views, Sql functions and locking issues.
• Documenting MS SQL Server database design, implementation and configuration.
• Interacting wif teh users and troubleshooting teh problems involved wif teh development of stored procedures.

Confidential

Senior Database Administrator

Environment: Microsoft SQL Server 2005, 2008, 2008R2 & 2012 Windows 2003, 2008, 2008R2, 2012 Server.

Responsibilities:

• Involved in installation and configuration of SQL server 2005, Applied patches and service packs to keep teh database at current patch level.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Responsible for General Database Administration and Performance tuning.
• Experienced in resolving deadlock and blocking issues for concurrent users.
• Developed Database Backup Scripts and automated this process.
• Applied patches and service packs to keep teh database at current patch level.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
• Supported production and development databases.
• Implemented SQL standards in writing stored procedures, Triggers, Views, Sql functions and locking issues.
• Documenting MS SQL Server database design, implementation and configuration.
• Interacting wif teh users and troubleshooting teh problems involved wif teh development of stored procedures.
• Managed 24/7 Database Environment (Dev, Test/UAT and Production).
• Installed, Configured, and Administered SQL Server 2008R2, 2012 in development, test, and production environment.
• SQL/T-SQL, Triggers, And Stored Procedure: Wrote SQL, T-SQL, Stored-Procedures and triggers.
• Assisted SQL developers to optimize SQL queries, Stored Procedures and Triggers.
• Monitoring and Performance Tuning: Performed database monitoring and Performance tuning.
• Monitor Servers activity, and worked wif clients to solve different problems.
• Performed index and statistics management.
• Managed SQL Server Error Logs, space usage, growth pattern.
• Used DBCC and ALTER C statements to check and manage database consistency, index fragmentation/rebuilding, statistics.
• Managed BLOCK and LOCK.
• Database Automation: Created Backup jobs for different types of backup like FULL, Differential and Transaction Log.
• Created Jobs for database maintenance Index fragmentation, rebuild, database statistics.
• Data Modeling: Worked on different Data Modeling projects using ERwin for designing Logical & Physical Database.
• Used Backward & Forward Engineering to create Logical and Physical database.
• Index/Constraints, Triggers, Stored Procedure: Created and managed Index (Cluster/Non-Cluster), Constraints.
• Security Management: Created and Managed users, group roles, schema, and security at object level, data encryption.
• Export & Import data from/to Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files to SQL Server 2005/2008.
• Database Migration: Migrated MS Access databases into MS SQL Server.
• Migrated Oracle 10g, MySQL database into MS SQL Server 2008R2.
• Imported data from Oracle,Excel, Flat file, CSV file to SQL Server Database,.
• Backup/Recovery: Work experience and strong noledge in disaster recovery.
• Rebuild databases using backups.
• Reports: Installed, Configured, and administered SQL Server Reporting Services (SSRS).
• Developed Reports using SSRS.
• Developed Ad-hoc Reports using Report Builder 3.0, 2.0.
• Deployed Reports.
• Managed security for reports.

Confidential

Senior Database Administrator

Environment: Microsoft SQL Server 2005, 2008 Windows 2003, 2008

Responsibilities:

• Maintained mission critical production database as well as production applications including Emergency off-hour support.
• Installed and configured SQL Server 2005, and 2008R2 on as standalone and Clustered Servers.
• Automating Database tasks (Created jobs, alerts, and schedules for database maintenance tasks).
• Wrote SQL/T-SQL codes, stored Procedures, Triggers and Functions.
• Helped database developers to tune up SQL/T-SQL Queries.
• Applied Service Packs, and hot fixes.
• Performed database backups, restored database from backup.
• Replication: Configured and maintained transactional and merge replication.
• Security Management: Access and security management like creating Logins wif appropriate roles. creating users and groups and granting and revoking privileges for data security.
• Migrated Oracle, MySQL, MS Access 2000/97 databases into MS SQL Server 2000and2005.
• Standby and Mirroring: Configured and Maintained Replicated database using Log Shipping and Replication in SQL Server 2000 and 2005 for high availability.
• Performed performance tuning: Using SQL Server profiler, Windows performance monitor and Database engine tuning advisor to analyze and fine tuning of long running queries and stored procedures and slow running servers.
• Documentation: Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices.
• Reporting Services: Installed, configured and maintained SQL Server 2000/2005 Reporting Service.