We provide IT Staff Augmentation Services!

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

We'd love your feedback!