We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

New, JerseY

SUMMARY:

  • IT Professional with over 8 years of experience as DBA. Excellent interpersonal skills in communicating with various business units, IT Teams, and vendors. Strong incident - problem management skills. Exceptional skills in database architecture, performance tuning and optimization, database administration, disaster recovery, backup/restore, and database security
  • Over 8 years of experience with MS SQL SERVER 2014, 2012, 2008R2, 2008/2005 Database Development and Administration (DBA) in Windows environment.
  • Expert in database server upgrade from lower version (SQL 2005/2008/2008 R2) to higher version (SQL 2012/2014).
  • Managed business expectation by providing HA/DR solution like Clustering (active-active, active-passive), AlwaysON (Availability group and WFCI), Mirroring, Log Shipping, Replication to achieve RPO and RTO requirement.
  • Management of complex database environment (over 100 SQL database instances) and capacity planning for database growth monitoring.
  • Experience in PROACTIVE monitoring which reduced databases related incident count by more than 75%.
  • Expert in SSRS, maintained more than 200 reports, scheduled them (data-driven subscription), setup of scale-out deployment, reduced SSRS load by utilizing execution snapshot, created history snapshot for audit purpose.
  • Expert in Performance Tuning and Optimization.
  • Expert in maintenance (backup, index, checkdb) of VLDB (1TB) database, partition, and compression
  • Implemented Resource Governor to control run away queries.
  • Experience with daily Change management (CAB) procedure to document changes affecting environment.
  • Expert in creating SOP for SQL Installation (Stand Alone, Cluster), SQL Patching, security (enforcing SOX), Mirroring, Log Shipping, AlwaysON.

PROFESSIONAL EXPERIENCE:

Confidential - New Jersey

Sr. SQL Server DBA

Responsibilities:

  • Performing SQL Installation, SQL Patching, Security permission (enforcing standards for SOX, PCI applications), Configuration, Always ON.
  • Support of regular database release and migration.
  • Implemented Database Maintenance tasks to reorganize and rebuild Indexes, implement Database Integrity Checks (DBCC) and Update Statistics on weekly basis.
  • Monitoring daily health check reports and taking needed action.
  • Working with development team and application team for DR test.
  • Upgrading and migrating SQL server from lower version 2008 to SQL 2014 and SQL 2016 and setup always on.

Confidential - New York City

Senior SQL Server DBA

Responsibilities:

  • Working on SQL environment (100+ database servers) to reduce licensing cost and leveraging resource governor to provide needed resources in shared infrastructure.
  • Experience working with Windows server, including Active Directory and also working with Physical and Virtual Machine.
  • Doing weekly DevOPS release by utilizing github and TFS
  • Regular code review before pushing any code to prod/ non-prod environment.
  • Maintenance of VLDB database of size 3TB
  • Creating and Scheduling PowerShell reports on non-prod environment and helping developers to write T-SQL scripts.
  • Worked with SSIS ETL data to perform Extract, transform and load data of our data ware house application and also working with SSRS to create reports.
  • Create SOP for Standard DBA/Development procedure like Patching, Installing SQL, and Migration.
  • Experience with PTO (Performance Tuning and Optimization) and code review.

Confidential - New York

SQL Server DBA

Responsibilities:

  • Created SOP for Migration (2008 2014), SQL Installation, SQL Patching, Security (enforcing standards for SOX, PCI applications), Mirroring, Log Shipping, AlwaysON.
  • Corrected SQL Licensing model to utilize all available CPU in SQL 2014 cluster.
  • Responsible for performance tuning of various application.
  • Maintenance of VLDB database of size 3.5TB
  • Administration of SSRS report, subscription and security, as well as troubleshooting SSRS issues.
  • Responsible for creating SSIS packages according to requirement as well as deploying and monitoring SSIS jobs.
  • Created SSIS package to automate some of DBA tasks to collect data to central repository database.
  • Managed non-production database servers in AWS to scale up/down on demand.
  • Worked with EMR (Electronic Medical Record) and EHR (Electronic Health Record) application. I also have worked with NextGen application and database with database size of 3.5 TB.

Confidential - New Jersey

SQL Server DBA

Responsibilities:

  • Consolidating SQL environment to reduce licensing cost and leveraging resource governor to provide needed resources in shared infrastructure.
  • Administration of SSRS report, subscription and security, as well as troubleshooting SSRS issues.
  • Responsible for creating SSIS packages according to requirement as well as deploying and monitoring SSIS jobs.
  • Created SSIS package to automate some of DBA tasks to collect data to central repository database.
  • Use of CyberArc for Privileged Account Management (sa, service account, application account) for security audits.

Confidential - New York

SQL Server DBA

Responsibilities:

  • Installed/Upgraded and Configured SQL Server for SQL 2014, 2012, 2008 R2, 2008, and 2005 for standalone and cluster environment (active/active, active/passive).
  • Maintained and deployed Central Repository databases to gather Server and Database related information to generate Health Check PowerShell Reports on daily basis for complex 40+ production database server (100+ production databases) environment.
  • Involved in various Root cause analysis reports for reactive situation and worked on long term resolution for repeating problems.
  • Administration of SSRS report, subscription and security, as well as troubleshooting SSRS issues.
  • Implemented database compression, partition and resource governor of data warehouse database with size of 2TB with 1TB (3TB total size) of storage savings
  • Designed the Backup-Recovery plans to minimize the data loss and faster recovery.
  • Troubleshooting Stored Procedures and Queries performances using SQL Server Profiler, Performance Monitor, DBCC Commands and Dynamic Management Views (DMVs).

Confidential - VA

SQL Server DBA

Responsibilities:

  • Upgrading from SQL Server 2005 to SQL Server 2008 and 2008 R2 in clustered environment.
  • Setup database mirroring with high safety with automatic failover (synchronous).
  • Installed Service Packs in Clustered environment in SQL 2008 and 2008 R2.
  • Backup, restore and maintenance of VLDB (1.4 Terabyte) database.
  • Created partition table using partition functions and partition scheme for VLDB database.
  • Setup Transactional Replication from Transaction Server to reporting Server.
  • Monitoring and troubleshooting performance during peak periods with more than 800 concurrent connections.
  • Maintaining both DEV and PRODUCTION servers in sync with Version control tool VSS.
  • Created users/login/roles and assigning minimum level of permissions with proper documentation for security Audits.

Confidential

SQL Server Developer/ DBA

Responsibilities:

  • Upgraded SQL Server 2000 to SQL Server 2005.
  • Documented and setup log shipping, database mirroring as HA/DR solution and created run book for DR Failover exercise.
  • Created stored procedures, triggers, views.

Hire Now