SUMMARY:

• I am a consultant who specializes in SQL Server performance tuning, high availability, disaster recovery, database design, development, and database administration.
• I am a well - rounded consultant who has worked on government projects, startup projects and projects for public sector corporations.
• DBA working with SQL Server/Oracle since 2006
• Extensive background in technical support and customer service
• Active contributor to SQL Server Community
• Good knowledge & experience on Cloud Computing like Azure/AWS
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2019, 2017, 2016,2014, 2012, 2008R2, 2005,
• Experience in Installation, Configuration, Maintenance and Administration of SQLServer/Oracle Servers
• Good experience in Database design & architecture
• Good Experience in Backup & Recovery scenarios
• Good experience in implementing High Availability & Disaster Recovery solutions using Always ON, Clustering, Replication, Mirroring and Log Shipping
• Good knowledge and understanding of Virtualization
• Expertise in Index tuning, rebuild, reorg strategies
• Experience in Data Centre Migration Activities
• Expert in Troubleshooting, Optimization and Performance tuning of SQL Server database server (Ex., Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck etc.)
• Process and Implementation - Extensive experience implementing software throughout the SDLC process, deep hands-on experience of networking, migration and implementation in Azure.
• Ensured the responsible for overall technical quality, migration, deployment standards and architecture of the application

TECHNICAL SKILLS:

Database Technology & Technical Skills: Microsoft SQL Server 2000-2019, T-SQL, SQL Server Reporting Services (SSRS) Administration & Automation Log shipping, Mirroring, Replication, AlwaysOn Availability Groups, Failover Cluster Instances, PowerShell, Azure Cloud services, AWS, Oracle, IaaS, PaaS

PROFESSIONAL EXPERIENCE:

Confidential, Windsor Mill, MD

Database Architect

Responsibilities:

• Service Architect for SQL Server & Microsoft Data Platform for both Azure, AWS & on-premises infrastructure
• Migration of SQL Server Instances from 2008 R2 to,2014,2017, 2019
• Migrating on-premises SQL Server Database to Azure SQL VM and Azure SQL DB
• Implemented new SQL Server features by performing successful POCs
• Worked with business teams to develop server architecture to meet project requirements, including HA/DR, business, and application needs
• Used PowerShell to automate routine tasks, such as new server deployment, server configuration, and server migration
• Assisted DBA team with routine operations, such as backup/recovery, performance tuning, etc. supporting SQL Server 2008 to SQL Server 2017 and Azure SQL Database
• Primary contact for relationship with our DBA Services vendor for monitoring & staff augmentation
• Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS)
• Experience in managing Very Large databases (VLDB) and troubleshooting problems
• Use of Query Store feature for monitoring performance of database systems
• Developed key metrics and reports to show Total Cost of Ownership for SQL Server environment, including server-level cost reports used for departmental cost show back
• Introduced Power BI to reporting environment to help facilitate executive-level dashboards
• Revamped existing restore and backup processes to provide standardization and improve RPO/RTO
• Maintained security policies per the DISA STIG for SQL Server and Oracle to maintain proper security procedures.
• Participated in security briefings to adhere to configuration and hardening guidelines.
• Supported software development team to assist in development activities and participated in maintenance activities, application releases, and change control board meetings.

Confidential, Annapolis, MD

Senior Database Administrator

Responsibilities:

• Managed 100+ different databases on two networks comprising of Production, Development and QAS environments
• Assumed direction of project to successfully upgrade from SQL Server 2008R2 to SQL Server 2014, including migration from Failover Cluster Instances to Availability Groups
• Leveraged existing hardware purchase and project goals to develop migration plan and execute migration
• Implemented standardized backups, maintenance, and monitoring of all database systems
• Implemented Multi-Server SQL Agent jobs to simplify management of 100s of SQL Agent jobs, including synchronization of jobs across Availability Group nodes.
• Worked with developers to identify and tune poorly-performing code
• Mentored Junior DBAs, focusing on education and professional growth, as well as day-to-day prioritization
• Created and maintained Standard Operating Procedure documents
• Reduced CPU utilization by 20% over 6 months, by focusing on performance in code review, as well as proactive performance monitoring & tuning
• Standardized backup process across all 100 servers in environment; Implemented automated process to regularly test restores of every database

Oracle DBA

Confidential

Responsibilities:

• Planned, installed and configured Oracle 11g and 12c databases
• Analyzed AWR to tune Oracle databases for better performance
• Created, tested and implemented backup and recovery plans and scheduled daily, weekly and monthly hot/cold backup solutions utilizing RMAN
• Performed routine database maintenance activities in development and production environments.
• Upgraded Oracle databases from 11g to 12c
• Implemented Oracle Patches (PSU) as needed to ensure databases are not vulnerable to outside intrusions
• Performed database monitoring and performance tuning using OEM 12c
• Extracted data from various data sources for loading into the database utilizing tools such as Data pump export/import, Oracle Migration Workbench and SQL*Loader
• Responsible for cloning production databases for testing and training

Confidential, Bowie, MD

Lead Database Administrator

Responsibilities:

• Supported highly-available (99.999% uptime) database environment for mission critical applications—including website hosting, and internal applications.
• Assisted in zero-downtime database release process for three-week release cycle
• Planned & executed multiple hardware migrations with zero downtime
• Developed a method to update system tables, allowing hardware migrations without downtime to replication
• Planned & executed performance tuning on production report server to reduce average CPU from 25% to 10%, allowing company to delay hardware upgrade by two years
• Created internal enterprise-scale SSRS environment that included separate development & production sites with self-service deployment mechanism
• Re-wrote performance monitoring code to improve reliability & scalability, making centralized collection more stable, and facilitating additions of new monitor metrics and new servers
• Scripted routine tasks to increase automation and reduce repetitive manual tasks

Confidential, Baltimore, MD

Database Administrator

Responsibilities:

• Lead DBA on the team brought in to bridge the gap between project being created and support team in India
• Manage 20+ Oracle databases on two networks comprising of Production, Development and Staging
• Designed, developed, implemented databases, database modifications
• Maintained indexes, developed and maintained recovery models, set up monitoring procedures, set up security for forward-support staff, developed code modification of data and schema
• Set up proper backup & restores based on RPO and RTO
• Set up and monitored Replication (Merge & Snapshot) between sites in U.S, India and United Kingdom.
• Automated and created procedures for consistent and repeatable results from all team members including offshore monitoring team
• Drove home major projects that had a high level of visibility; DR, QA/Stage, deployment automation, new applications monitoring and upkeep
• Implemented process improvements to give the company better coverage and improve the effectiveness of the team
• Improved performance of previously-existing database environments; including locking/blocking issues, re-indexing & stats updating, proper index design, query tuning & education
• Configured and setup features such as Policy Based Management, Data Compression, Resource Governor and Transparent Data Encryption (TDE)
• Ensured high availability of large hosting environment, including 24x7 on call rotation
• Hosting environment consisted of apx 100 SQL instances & 10,000 databases
• Median database size apx 20GB. Largest database apx 2+ TB
• Assisted Oracle team in performance tuning SQL & PL/SQL queries and procedures
• Developed utility scripts & stored procedures for use in daily maintenance, troubleshooting, and operations
• Acted as fourth tier support for complex support issues for hosted clients, including performance analysis & tuning
• Performed troubleshooting, resolution, and root cause analysis for database & application-specific incidents
• Completed project working with EMC² to implement Data Domain as backup device for all hosted databases
• Supported software development team to assist in development activities and participated in maintenance activities, application releases, and configuration management boards

Team Lead

Confidential

Responsibilities:

• Provided high-level technical support for clients running Oracle Forms-based software and Oracle databases
• Developed, tested, and deployed bug fixes, data fixes, and bug fix backports to resolve client issues
• Performed troubleshooting & optimization for performance issues—including performance-tuning of SQL & PL/SQL code, as well as index & database-level changes to improve performance