Consultant SQL DBA Resume Cranford, New Jersey - Hire IT People

SUMMARY:

Over 8 years of experience in Database Administration and Support of Microsoft SQL Server 2014/2012/2008 R2/2008/2005 in Production, Test, Development, Replication and Failover Cluster environments

TECHNICAL SKILLS:

SQL Servers & Tools: SQL Server 2005/2008/2008 R2/2012/2014, Azure cloud, Export/Import, PowerShell, SQLBackup, Lite Speed, Red Gate, Idera, SQLSafe, and Backup Exec.

ETL Tools: SSIS

Data Modeler: SSAS

Reporting & Audit Tools: SSRS, Report Builder, Idera SQL Compliance Manager and SQL Secure.

Virtualization: VMware

Third Party Tools: RedGate, Spotlight, and IderaSQLsuite, Ola Hellengren and Brent Ozar s Maintenance Scripts

DB Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, SSMSOperating System Windows 7, 8, 10, Windows NT/ 2000/2003/2008 and 2012 servers

PROFESSIONAL EXPERIENCE:

Consultant SQL DBA

Confidential | Cranford, New Jersey

Responsibilities:

Installed and Upgraded from SQL server 2008, 2008 R2, 2012 to 2016 (rolling upgrade)
Migrated Databases from SQL Server 2012 to SQL server 2014 and 2016
Installed and administered failover cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment
Provided 24/7 support during the migration process
Worked with the System Administration team and Network Administration team during the windows clustering creation.

SQL Server DBA

Confidential

Responsibilities:

As a production L2 support, was responsible for resolving incident tickets escalated from L1 support and handling critical incidents (Sev1, Sev2 high)
Responsible for installing, configuring, and maintaining databases as per supported LOB applications
Created necessary T SQL scripts, stored procedures, tables, views, functions, triggers and indexes
Created automation of day - to-day operations, critical SQL server alerts and repetitive tasks
Monitored the health and performance of SQL server instances and in-house applications using Extended Events, SQL server Profiler, PerfMon and other third-party tools
Setup and maintained Log Shipping between various environments

Junior SQL Server DBA

Confidential

Responsibilities:

As a L2 support, we worked on incident tickets escalated from L1 support team.
Responsible for MS SQL Server 2005 and 2008 and database administration.
24x7 critical production support for hundred and ten SQL Servers out of which 75 were mission critical production support.
Created database maintenance plans for SQL backups, optimization, and integrity check and t log backups.
Created databases, tables, indexes, stored procedures and triggers, alerts and maintained user permissions.
Applied monthly patches and hot fixes.

We provide IT Staff Augmentation Services!

Consultant Sql Dba Resume

Cranford New, JerseY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship