PROFESSIONAL SUMMARY:

• Results oriented DBA professional with 6 plus years of diverse experience in database design and systems development with proven expertise in database administration, design, development, and implementation.
• Well versed in supporting broad scale mission - critical database systems including configuring high availability, scalability, and disaster recovery.
• Installation/Configuration
• SQL Server Migration
• Clustering
• Database Optimization
• High Availability
• Disaster Recovery
• Database Modeling
• Automation, Implementation & Testing
• Deployment of SSIS and SSRS packages
• Performance Monitoring
• Backup and Restore
• PowerShell
• Maintenance and Troubleshooting
• Value-Added Team Leading
• Leveraging Team Skills

SKILLS:

• Installing, Configuring, and Administering MS-SQL 2005, 2008, 2008R2, 2012, 2012R2, 2014, 2016, and 2017 (testing status in production) on Standalone and Clustered environments.
• Upgrading MS-SQL Server from older versions to newer versions.
• Applying Service Packs and Patches (SPs) on servers.
• Experience on configuring High Availability solutions such as Log shipping, Mirroring, Windows Failover Cluster, and in depth understanding on Always-On.
• Implementing different types of Replication Models such as Snapshot, Merge, Transactional, and Peer to Peer (P2P).
• Performing Full, Differential and T-Log backups as routine operations.
• Preventing disaster events from occurring and to detect issues before they occur with Disaster Recovery Plans.
• Extensive experience in Capacity Planning, Performance Tuning, and Trouble Shooting Procedures.
• Configuring, deploying, scheduling, managing, and troubleshooting SSIS Packages.
• Configuring & deploying package using SQL Server Reporting Service (SSRS).
• Excellent commutations with multifunctional teams, programmers, and technical staff at all levels.
• Ability to meet deadlines and yield effective results, while working independently and in teams.
• Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL ENVIRONMENTS:

• Microsoft SQL Server 2008/ 2008R 2/ 2012/ 2014/ 2016 , Microsoft Access, Oracle
• Windows Server 2000/2008/2008 R2/2012
• SSRS, Report builder and SSDT, Idera SQL compliance manager and SQL secure
• VM-Ware and Hyper-V
• IIS, Visual Studio, SharePoint
• MS SQL Server Integration Services (SSIS), Data Transformation services (DTS)
• RedGate, Spotlight, Idera, Erwin, Toad, Solar Winds, SCOM
• MS SQL Server Query Analyzer, SQL Profiler, ETL, SSMS, Enterprise Manager, PL/SQL Developer
• IBM Power 750 Express Server, SAN-Clariion CX4 Model 480, NCUBE, AMD64, HP 3000, DEC Alpha, RS 6000, Sun 3's, Sun SPARCstations, VMS 6000, Alpha AXP

PROFESSIONAL EXPERIENCE:

Confidential, Maryland

DBA

Responsibilities:

• Installed, configured, and administered MS SQL server 2012, 2014, 2016, and 2017 (testing status in production).
• Installed, configured, and managed VMware ESXi 5.5, 6.0 and 6.5
• Successfully installed, configured, and administered a traditional SQL Server failover Cluster with 4 nodes.
• Configured, added, and managed multiple databases on HA Groups with Always-On
• Responsible for designing and implementing the backup strategy required as per the requirement on production and development environments.
• Developed automated daily, weekly, and monthly SQL server agent jobs such as a database backup, integrity checks, and indexing maintenance and update statistics
• Administered the MS SQL Server security in relation to users, logins, and groups, Principle of Least Privilege (PLP), Securable, Permission, Roles and Authentication Modes as a part of Security Policies.
• Served as a “point of resolution,” closely monitoring disk space, system load, Disk IO, CPU, and memory usage to identify top SQL processes and troubleshoot performance issues.
• Worked in close collaboration with other teams to rollout 60 deployments ranging from simple support to large and complex projects .
• Wrote T-SQL Scripts to generate database performance related SSRS Reports.
• Performed various troubleshooting methodologies to identify and resolve system and user related issues.
• Implemented a DBA maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space) on production and test environments.
• 24 x 7 On-Call production support.

Environment: About 500 total servers each hosting small to very large size databases on both physical and virtual machines including; development, test, QA, and production servers. Tickets (JIRA, Team Track and Service Desk), Solar winds, SSIS packages, DBCC scripts

Confidential, Georgia

DBA

Responsibilities:

• Monitor current (as-is) manual/auto processes for efficiency, productivity, and access issues to quickly identify bottlenecks, performance delays, and gaps in the current process vs. the desired (to-be) process maps.
• Minimize response time required to resolve system slowdown and system shutdown by troubleshooting issues related to database, connection issues, SQL server slow response, query issues, and permissions .
• Safeguard organizational data with a physical standby for disaster recovery and logical standby for reporting in addition to managing security using SQL logins, roles, and security protocols for various users.
• Optimize performance with upgrades such as the migration from SQL server 2008/R2 SQL servers to SQL server 2012, successfully integrating new features and improved database stability .
• Improve efficiency with the creation of tools to interact with multiple databases that resulted in easy oversight of free space, data, system resources, and smooth facilitation of reports and deliverables.
• Impact system performance by tuning long running queries to increase load time while adding additional indexes, changing access paths, rewriting queries, and adding partitioning.
• Installation and configuration of Windows Server 2008/2008R2/2012/2014 including the set-up of Active Directory, Domain Controller, DNS and DHCP servers and Windows failover cluster.
• Installation, configuration, and administration of SQL Server 2005, 2008, 2008R2, 2012 and 2014.
• Creating and managing databases, schema objects such as tables, views, indexes, procedures, triggers and database constraints to meet business requirements and policies and maintained referential Integrity.
• Implemented SQL server high availability solutions/tools like Log shipping, Mirroring, and Replication as well as carefully scheduled maintenance plan.
• Installed and configured a traditional SQL Server failover Cluster with 4 nodes.
• Configured, added databases, and managed Always-On High Availability Disaster Recovery techniques.
• Created SSIS Packages for Data Flow, Object Migration and Database Maintenance.
• Design, Develop and Implement SQL Server Reporting Service that extracts data and present in the user-friendly formats.
• Created complex stored procedures, help developers to optimize queries, triggers, database design and UDFs to support efficient data storage and manipulation.
• Created linked servers to perform distributed queries and data transfer.
• Apply SQL Server patches, Service Packs, and Cumulative Updates as required and created documentation for tracking.
• Monitored health of databases (OEM) and analyzed key performance metrics while also creating automated scripts for additional monitoring.
• Assisted developers in the process of Extract, Transform, and Load (ETL) in data warehouse.
• Run DBCC commands to check the database consistency and shrink the databases.
• Manage Very Large databases (VLDBs) of 1TB and more using Table Partitioning, Backup and data Compression and Multiple file-groups.
• Overall follow-up of the system and user support to address any issues and plan for potential problems in advance.
• Provided 24x7 on call production support.

Environment: About 600 servers both in production and non production settings, on physical and virtual machines, MS SQL Server 2005, 2008 R2, 2012, and 2014, SQL Profiler, System/ Performance Monitor, Activity Monitor, ETL, Quest spotlight, SQL Lite speed, PowerShell, SSRS, SSIS, SSAS, Hyper-V, Data Warehousing, High Availability/Always On, Visual Studio, SharePoint and Others.