SQL DBA Resume

SUMMARY:

Experience in RDBMS database design,performance tuning, optimization, backupand recovery in SQL Server 2008/2008R2, SQL Server 2012
Experience inDisaster Recovery Planning, Execution and Testing at remote site
Experience in using SQL Server Tools like Import/Export Wizard, SQL Server Enterprise Manager, SQL ProfilerandSQL Query Analyzer.
Solid experience onHigh availability(Always - On) SQL Server solutions, includingReplication Models(Snapshot/Transactional)
Expert in setting up maintenance plans, creating jobs, database mail.
Expert in E.T.L TOOLS (S.S.me.S, B.C.P, Import & Export Wizard).
Expert in S.S.R.S

PROFESSIONAL EXPERIENCE:

Confidential

SQL DBA

Responsibilities:

Vomoz Communications is a leading telecommunications provider wif a very large database consisting of customer(s) full information. The primary objective here was to maintain customer(s) records and make various databases accessible to users. Various plans were considered during the planning, as to the downtime databases can be offline/unavailable, and recovery plans.
Microsoft SQL Server DBA wif 5+ years of experience in design, Development andAdministration using MS SQL Server 2008, 2012 database environments.
Extensive experience on both SQL Server Administration and T-SQL Application Development
Knowledge of Normalization/ Denormalization techniques for OLTP and OLAP environments.
Used SQL Indexes for improving query performance, lower storage and maintenance cost.
Experience in optimization tools such as SQL Profiler, Dynamic Management Views (DMVs)
And Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
Hands-on working experience in Installing, configuring, upgrading and managing SQL Server
2008/2012 and upgrading Service Packs for multiple instances.
Good experience in user management for DBs, maintaining of databases, and providing SQL
Server security by assigning logins, server and database roles and server permissions.
Participated in Disaster prevention and Recovery Strategies and supported High availability features like Snapshot Replication, Clustering (Active/Passive) and Database Mirroring.
Experience in Log Shipping from Primary to Standby servers and SQL maintenance plans.
Experience involved in using tools like SQL profiler for Monitoring and Tuning MS SQL Server.
Proficient in developing business application logic using SQL Stored Procedures, Functions and
T-SQL queries and maintained code repository in Visual Source Safe (VSS) for deployments.
Created and maintained SQL objects like Tables, Constraints, User defined Functions, Indexes,
Views, Stored Procedures and SQL scripts, T-SQL queries for developer applications.
Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL
Server agent and monitoring and troubleshooting jobs, event notifications using Database Mail.
Developed Tabular Reports, Matrix Report, and Charts using SSRS and deployed to Report Server.
Extraction, Transformation and Loading (ETL Tools) data using DTS/SSIS Import/Export utility

International Relations Specialist

Confidential

Responsibilities:

Provided support in the development of strategic assessments form international relations and foreign affairs perspective.
Conducted research and analysis on issues associated wif mission sets.

Assisted wif developing facts, assumptions, and limitations in order to accurately frame the situation through the development of a multi-perspective understanding.
Research and Collection of data on various health issues for development. Health issues such as genital mutilation, adult circumcision, lack of awareness of sexually transmitted diseases.
Monitoring the Progress of Millennium Development Goals wif regards to Health before the 2015 set date.
Project Implementation
, Analysis of data involving report writing

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship