We provide IT Staff Augmentation Services!

Sr. Ms Sql Server Dba/architect Resume

3.00/5 (Submit Your Rating)

Vernon Hills, IL

Hire Now

PROFESSIONAL SUMMARY:

  • Results - oriented, and high-performing professional, with over 20 years of experience in database development and administration, with demonstrated expertise in installation, configuration, and troubleshooting of MS SQL Server versions.
  • Proficient in the following programming languages:HTML,Classic ASP/VBScript/JScript,ASP.NET,Java
  • Highly Skilled in the following databases: MS SQL Server, Oracle 9i/10g/11g, Sybase 12.5
  • Expert in TSQL programming, working with multiple ETL tools (DTS, SSIS, Data Junction, Oracle Loader, BCP In/Out), automating SQL installs and patch implementation using VBScript.
  • Big Data, inclduing Hadoop Ecosystem (Spark, Hive, Sqoop).

PROFESSIONAL EXPERIENCE:

Confidential, Vernon Hills, IL

Sr. MS SQL Server DBA/Architect

Responsibilities:

  • Managing the company's database servers on premises and in the Cloud (MS Azure).
  • Planning and implementing AlwaysOn.
  • Planning and implementing database upgrades and migrations.
  • Database Performance Tuning (configuration best practices, Identifying resource bottlnecks, poorly performing queries and Indexes ...).
  • Automating database tasks using Power Shell

Confidential, Chicago, IL

Sr. MS SQL Server DBA/Architect

Responsibilities:

  • Maintaining SQL Server instances on premises and in the Cloud (AWS).
  • Supporting BI infrastructure and developing ETL processes using SSDT.
  • Programming Transformation Logic and populating data into PDW(Parallel Data Warehouse) tables.
  • Planning database migrations from older versions to SQL Server 2016.
  • System Resource monitoring and Performance Tuning
  • Deploying Hadoop cluster in the AWS Cloud (Linux Ubuntu)
  • Accessing data and developing ETL in\out of HDFS using Spark, Hive and Sqoop.
  • Ingesting data into APS (Analytics Platform System) from MS SQL Server (using Sqoop, JDBC)
  • SQL Server integration with Hadoop (using PolyBase)

Confidential, Chicago, IL

Sr. MS SQL Server DBA

Responsibilities:

  • Supported P2V migrations, Database migrations and database upgrades.
  • Led efforts for Patch Management and A utomation.
  • Configured Replication, Transaction Log Shipping, Mirroring, Clustering, and Always On.
  • Installed\configured\troublshooted MS SQL Server and Oracle software.
  • Supported ETL, SSIS processes into SQL and Oracle.
  • Performance Monitoring and Tuning (indexes/statistics/blocking/deadlocks, plan cache).

Confidential, Arlington Heights, IL

Sr. MS SQL Server/Oracle DBA

Responsibilities:

  • Installed/Configured/Troubleshooted MS SQL Server 2008/2012/2014 instances.
  • Supported with V-Block migrations.
  • Supported DR/HA environments.

Confidential, Elmhurst, IL

Sr. MS SQL Server/Oracle DBA

Responsibilities:

  • Installed/Configured/Troubleshooted MS SQL Server 2008/2012 instances on physical, VM hosts.
  • Planned, implemented database migrations from older versions to MS SQL Server 2012.
  • Assigned/Scheduled Change Requests to off-shore DBAs.

Confidential, North Chicago, IL

Sr. MS SQL Server/Oracle DBA

Responsibilities:

  • Built new SQL instances for various projects.
  • Planned and implemented database migrations from older versions to MS SQL Server 2012.
  • Implemented Change Management requests.

Confidential, Rosemont, IL

Sr. MS SQL Server DBA

Responsibilities:

  • Installed/Configured/Troubleshooted MS SQL Server software.
  • Reviwing\Promoting SQL code to produciton.
  • Performance Tuning.

Confidential, Schaumburg, IL

Sr. MS SQL Server/Oracle DBA

Responsibilities:

  • Installed/Configured/Troubleshooted MS SQL Server and Oracle 9i/10g (on Sun Solaris 2.8).
  • Created SQL and Oracle tables, views, indexes, and coding PL/SQL.
  • Disaster Recovery Planning, Implementation and Monitoring.

Confidential, Vernon Hills, IL

Sr. MS SQL Server DBA

Responsibilities:

  • Installed/Configured/Troubleshooted MS SQL Server software.
  • Reviewed and promoted developers’ scripts to QA and Production.

Confidential, Schaumburg, IL

Sr. MS SQL Server DBA

Responsibilities:

  • Database Security Analysis/Monitoring and providing reports to internal auditors.
  • TSQL programming for various auditing requests.

Confidential, Chicago, IL

Sr. MS SQL Server/Sybase DBA

Responsibilities:

  • Installed/Configured/Upgraded MS SQL Server 7/2000/2005 and Sybase 11 software.
  • Migrated Sybase databases to MS SQL Server 2005 (reverse engineering and reconciling stored procedures).
  • Synchronized Database Schemas in Production, QA and Development Environments.
  • 2nd level DBA support of Sybase (11.03, 12.0, 12.5) on Sun Solaris 2.6.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship