Sr. SQL Server DBA Resume Sr. SQL Server DBA - Hire IT People

SUMMARY

SQL Server dba with more than 11 years of experience. Areas of expertise include Database Administration, Database tuning, Database development, Data modeling, Database Security, Database migration.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Sr. S QL Server DBA

Confidential

Responsibilities:

Administration, configuration and maintenance of production databases (SQL Server 2012, 2014) this involves the tuning, monitoring, upgrade implementation, security, recovery, data load and maintenance of the SQL Servers of Dev, QA and production.
Upgrading SQL versions, from 2012 to 2016, creating from scratch all the project requirements and areas involved for this achievement.
Creation of documentation of the databases, and Change request processes that did not exist in the company.
Solving user requests and Jira tickets.
Improve coding and reduce time in operation response for several ETL´s that were created previously.
Implement security measures, administration and preventive measures for all environments with SQL Server
Migrate their SQL Servers from 2008 and 2012 to 2016 to a private cloud with less impact and enhanced security .

Sr. SQL Server DBA

Confidential

Responsibilities:

Administration, configuration and maintenance of production databases (SQL Server 2012, 2014, 2016) this involves the tuning, normalization, monitoring, upgrade implementation, security, recovery, data load and maintenance of the SQL Servers of Dev, QA and production.
Upgrading SQL versions, creating from scratch all the project requirements and areas involved for this achievement.
Creation of DRP, Capacity planning, documentation of the databases, and Change request processes that did not exist in the company.
Improve coding and reduce time in operation response for several ETL´s that were created previously.
Implement security measures, administration and preventive measures for all environments with SQL Server.
Creation of standards, guidelines and tutorials of best practices for developers, reporting and data-warehouse areas.

Database Architect

Confidential

Responsibilities:

Creation of cubes, fact tables, dimensions, ETL's and E-R models.
Create high level reports (very complex queries) using Power BI, SSRS, SSIS and Datazen.
Database best practice implementation, high level support and guidelines for developers and dba´s, code reviewing using TFS, to create normalized databases, enhanced coding and reducing retrieval timing and costs.
Analysis of new technology to validate their value on the company to reduce time, costs and implementation.
Improve coding and reduce time in operation response for several stored procedures that were created previously.
Implement security measures within SQL Server (DDM, Always Encrypted, Symmetric Key, etc.), reducing costs of implementation and training for developers and database administrators.
Creation of standards, guidelines and tutorials of best practices dedicated to development and dba's.

Sr. SQL Server DBA

Confidential

Responsibilities:

Administration, configuration and maintenance of production databases (SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016) this involves the tuning, normalization, monitoring, upgrade implementation, security, recovery, data load and maintenance of the SQL Servers of Dev, QA and production.
Upgrading SQL versions (From SQL Server 2012 to SQL Server 2014 and 2016 SP1), this involved a huge planning and coordination with other areas for this achievement.
Reduction of time of implementation of the DRP's by automating process using scripts and jobs.
Implementation of high availability process such as Always On, Log Shipping and replication of databases for DRP.
Support to Oracle dba’s running scripts, using pl/sql, XShell, lab128 monitoring tool, toad for Oracle.