SQL Server Database Administrator Resume

SUMMARY

A certified Microsoft SQL Server Database Administrator seeks a position with new challenges and opportunities to grow in a performance - driver environment.
I have 5 years of proficient experience in implementing Installation, Configuration, Upgrade, Migration, Backup/Recovery, Security, Performance Tuning, Disaster Recovery, and High Availability solutions in Always On, Clustering, Replication, Database Mirroring, and Log shipping, Data Modeling in different database environments.
I am task oriented with demonstrated analytical abilities, and excellent communication and interpersonal skills working in a team as well as independently.

TECHNICAL SKILLS

Databases Administration: SQL 2016, 2012, 2008R2

Operating Systems: Windows Server 2012, 2008

Database Migration: Oracle 11g to SQL Server

Monitoring Tools: Performance Monitor, Execution Plan, Error Logs, Activity Monitor, DB Engine Tuning Advisor, Extended Events, Wait Stats, DMV, DBCC, SP, Trace Flags, Idera DBA Suite, Idera (SQL compliance manager)

Scripting Languages: T-SQL, SQL, HTML, PHP, Java

ETL and Reporting: SSIS, DTS, SSRS

Data Modeling: Toad Data Modeler, ER Diagrams

Application: Migration Assistant, SharePoint, Active Directory, EFS Phoenix shared drive

CMS: WordPress, Drupal

Familiar: Amazon Web Services, Azure

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Database Administrator

Responsibilities:

Apply Service Pack, cumulated updates and hot fixes on SQL Server 2008 R2, 2012 and 2016
Setup database maintenance plans to schedule backups, manage indexes, update statistics, and clean up history on servers
Recover databases from backups in failures including performing Point-In-Time Recovery
Create automation jobs to execute stored procedures, delete old snapshots and shrink log files
Monitor and troubleshoot AlwaysOn, Clustering, and Replication High Availability solutions
Create table partitioning for large tables to optimize query execution and improve performance
Use system monitor, SQL Server Profiler and other tools to troubleshoot CPU/memory/ IO bottlenecks that negatively impact performance.
Perform daily monitoring of SQL Server Error Log, space usage, Events and automated Jobs
Perform database maintenance including routine integrity and performance using DBCC Commands, and DMVs
Setup and manage SQL Server security policy, transparent data encryption, and object level security
Administer security through user account management, logins, roles and views
Upgrade databases from SQL Server 2012 to SQL Server 2016 using sided by side method
Migrate Access 2010 data and Oracle 11g databases into SQL Server 2012
Export and Import data from Flat file, CSV file to and from SQL Server Databases using Insert into, DTS, SSIS, and BCP
Create database objects including functions, stored procedures, triggers and indexes for different business rules, requirements and auditing purposes
Perform and document scheduled failover to remote sites to test the planning and confirm High Availability and Disaster Recovery procedures
Develop and periodically update technical documentation
Execute data integration between applications and systems to promote business processes
Manage and resolve trouble tickets for server and database-related issues submitted by users

Confidential

SQL Server Database Administrator

Responsibilities:

Performed installation, configuration and management of SQL Server 2008R2 to 2012
Upgraded databases from SQL Server 2008R2 to 2012
Configured Log Shipping for Reporting purpose
Managed high availability solutions Log Shipping and Database Mirroring
Participated in data modeling projects and generated ER Diagrams using Toad Data Modeler
Created various database objects including, stored procedures, functions and triggers, functions
Created maintenance plans to automate tasks in the daily database administration
Monitored databases for optimal performance using SQL Profiler, Wait stats, DMVs, Activity monitor, Extended Events, Error log, and Performance Monitor
Automated database refreshes from production to lower environments
Performed daily tasks such as confirming backups and monitoring SQL Server disk drive space
Created and managed database security, transparent database encryption, and applied object level security
Imported, exported and manipulated data using ETL SSIS/DTS packages, BCP data from flat files, MS Access, MS Excel, and Other OLE DB databases to SQL Server databases
Migrated databases from Oracle 11g to SQL Server

Confidential

Database Analyst

Responsibilities:

Acquired and analyzed datafrom primary and secondarysources to ensure quality and functionality
Import and export data from different sources and using different tools
Managed the Extract, Transform and Load (ETL) process to compile and generate data reports
Converted Access database to the SQL Server environment
Participated in defining project requirements and process improvement opportunities according to business rules

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship