Sr. Sql Dba Resume
2.00/5 (Submit Your Rating)
Pittsburgh, PA
SUMMARY
- 16+ years of experience in IT Services and Operations which includes:
- 12+ years administering MS SQL Server databases, SSIS packages, SSRS reports hosted on versions 2017, 2016, 2014, 2012, 2008R2, 2008 and 2005
- 1+ years of experience administering Confidential BizTalk 2009
- 2+ years of experience administering Informatica 7.1.1 and 8.5.1
- Experience in planning, designing and implementing enterprise Database Infrastructure Architecture
- Experience working in large enterprise database environments with over 10,000+ databases
- Experience in administering large databases with size up to 4TB
- Experience administering SSIS packages, SSRS reports
- Created reports using Power BI and deployed to on - premises Power BI Report Server
- Experience in planning and implementing efficient High Availability and Disaster Recovery solutions
- Experience configuring and administering multi-node, multi-site and multi-subnet SQL Failover Cluster Instances
- Experience in configuring and administering Always-On Availability Groups and Database Mirroring
- Experience in replication using Transactional Replication and Snapshot Replication
- Experience in planning and coordinating database upgrades and migrations
- Experience in preparing operational database / server performance baselines for capacity planning / scalability requirements
- Experience in develop, establish, audit, review and enforce Standard Operational Policies and Procedures
- Experience in designing and implementing enterprise wide Database Backup strategy based on Recovery Point Objective (RPO) and Recovery Time Objective (RTO)
- Experience in Troubleshooting and documenting root cause analysis
- Experience in managing Virtual Machines hosted on VMWare and Nutanix
- Experience in physical storage SAN configuration on different RAID levels
- Experience in SQL Server Standards and Hardening
- Experience working in SOX, PCI, HIPAA, CJIS compliant environments
- Experience in leading team members spanned across multiple geographies
- Worked in 24/7 on-call support model to support critical databases
- Experience in ITIL process Change Management, Release Management, Problem Management, and Incident Management
TECHNICAL SKILLS
Operating Systems: Windows Server 2000, 2003, 2008, 2012, 2016, RedHat Linux
Tools: Idera Diagnostic Manager, SQL Safe, LightSpeed, SolarWinds Orion, Commvault, Erwin, Toad, SQL Squirrel, Team Foundation Server (TFS), Visual Source Safe (VSS), Mercury Load Runner, Visio
Domain: Software, Oil and Gas, Consumer Electronics, Chemical, Insurance
PROFESSIONAL EXPERIENCE
Confidential, Pittsburgh, PA
Sr. SQL DBA
Responsibilities:
- DBA assistance for 1500+ SQL databases hosted on SQL 2008/R2, 2012, 2014 and 2016
- Provided technical leadership for other database administrators
- Plan to migrate multi-node SQL Failover Clusters to Nutanix platform
- Created operational reports using on-premises PowerBI
- Configured SSRS 2017 and migrated reports
- Created scripts to automate SQL builds
- Created scripts to automate self service database restores
- Participated in troubleshooting application databases
- Provided off hour database support escalations as required
Confidential, Seattle, WA
Sr. SQL DBA SME
Responsibilities:
- Designed enterprise data-tier taking into account widely varying requirements of different applications and availability requirements
- Assisted in scheduling and implementing the migrations to ensure minimal user impact and downtime
- Analyzed the resource utilization and prepared plan to consolidate the databases from different Instances
- Prepared migration playbooks for migrating databases, SSIS packages, SSAS cubes and SSRS reports
- Created various inventory reports and published to on-premises Power BI Server
- Created enterprise wide central repository of all Instances and databases
- Created a centralized platform for monitoring and alerting
- Designed SQL VM templates for deployment. Created scripts to automate deployment
Confidential, Bellevue, WA
Sr. SQL DBA
Responsibilities:
- Worked as part of the OneOps Production and Lab support team responsible for administering 10,000+ SQL databases
- Experience monitoring and troubleshooting execution of various ETL jobs
- Monitored database performance and resolving slow running queries
- Administered multi-node Failover Clusters, Transaction Replication and Log Shipping
- Worked on deploying SQL and OS patches
- Worked with database developers and application teams to analyze and resolve database performance issues in areas such as missing indexes, execution plans, statistics, etc
- Migrated Analysis Services Cubes to SQL 2016
- Worked on refreshing multi-terabyte databases using storage replication techniques
Confidential, Seattle, WA
Sr. SQL DBA
Responsibilities:
- Redesigned the SQL Server environment with High Availability and Disaster Recovery (multi-site)
- Lead the effort to migrate databases from SQL 2008 R2 to SQL 2014
- Participated in architectural, design and Planning meetings
- Implemented High Availability environments on VMWare and Nutanix virtual infrastructure
- Worked with SPU operations and Project Management staff to review the project status
- Coordinated the deployment in conjunction with various Seattle Public Utilities teams
- Provided documentation for pre-migration test methods as well as smoke test after the database migration
- Created supporting documentation relating to the application/data tier
- Redesigned current database backup using CommVault
- Re-housed existing Physical servers from Seattle Data Center to WDC
- Worked with in-house developers and provided assistance during migration and other database related issues
Confidential, Redmond, WA
Sr. SQL DBA
Responsibilities:
- Setup High Availability and Disaster Recovery environment using and AlwaysOn
- Build 3 node Cluster
- Performance/Scalability analysis to root cause issues and also validate design alternatives aimed at solving issues
- Perform performance impact of tuning on/off a feature and doing experiments to arrive at best practices
- Migrate SQL databases from SQL 2014 to SQL 2016
- Coordinate with multiple application team and perform Disaster Recovery test
Confidential, Seattle
Sr. SQL DBA
Responsibilities:
- Managed databases hosted on high availability 4 node active-active cluster
- Managed databases hosted on remote ship servers
- Managed Confidential Business Intelligence environment for Global BI team
- Plan and coordinate in completing the migration of ship databases from SQL 2008 / SQL 2008 R2 to SQL 2012
- Worked on cross data center Disaster Recovery Test Process using SAN Replication.
- Set up alerts, operators, Database Mail and notifications. Configured and monitored database and server health through Dell Spotlight tool
- Controlled and coordinated the manual and automated installations (Security Patches, Service packs ) and evaluated the performance and risks before deployment
- Implemented data partitioning for MS SQL Server 2012 databases (Created partition function, partition scheme mapped to a partition function and created the table on the partition scheme).
- Performance Tuning, client/server connectivity and database consistency checks using DBCC utilities
- Identify and resolve locks / long running queries and performance related issues
- Coordinate database problem resolution activities with various project teams and conduct root cause analysis
- Manage legacy / special server environments having different business critical applications residing on High Availability servers
- Work with Wintel & Storage teams on Capacity Planning of SQL Server hardware and in configuring the storage to the servers
- Standardize the database maintenance across shore and ship side SQL Instances
- Prepare various operational and business reports using complex T-SQL scripts
- Assist development team and address performance issues
