SQL DBA Resume

SUMMARY

SQL Server DBA with experience in project management, people management, solution development, system integration roles in a career spanning 15 years, giving a well - rounded experience on various customer scenarios.
Experience in SQL database administration on production, staging & development servers with server configuration, performance tuning, and maintenance with excellent troubleshooting capabilities.
Experience in Disaster Recovery Planning, SQL Server Replication, Backup/Recovery and Security Management operations. Having hands on experience in DR processes including Log Shipping and Database Mirroring.
Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
Extensive experience in Installation, Configuration and Deployment of SSRS using ScaleOut, ScaleUp and Local topologies.
Create, manage SQL Server AZURE Databases. Setting up SQL Azure Firewall. Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.
Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
A multidimensional profile with Six Sigma Green Belt, capable and experienced in handling Database Administration, project, people and solutions management.

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA

Responsibilities:

Migrating database to RDS instance.
Setting up Connection Strings and connecting to SQL Server RDS instances from locally Installed SQL Server Management Studio (SSMS) for Developers.
Querying servers for getting details of users/logins.
Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
Performed Production support and on Call duties.
Developed, deployed and monitored SSIS Packages for new ETL Processes.
Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.

Confidential

SQL DBA

Responsibilities:

Configure trace to identify users/logins accessing orphan/unmapped servers.
Responsible for all SQL Server General Administration and Performance.
Setup backup and restoration jobs for development and QA environments.
Performed installation of SQL Server & Service Packs.
Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
Migrated SQL server 2000 to SQL Server 2008R2/2012.
Migration of DTS packages to SSIS packages.

Confidential

SQL DBA.

Responsibilities:

Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
Ensure all the SQL SERVER features worked as expected after consolidation or fail over.
Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
Help the developers & testers understand & debug issues related to SQL Server.
Security and architectural planning issues met as well as testing and training.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Used DBCC checks to ensure the physical consistency of the database and objects post failover & consolidation.
Providing support to the Application developers on the application databases.
Performed Production support and on Call duties.

Confidential

Lead Developer

Responsibilities:

Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
Stellar role in implementation of Speciality Liability certificate project resulting in online & almost intervention free issuance of Speciality coverage. This was a Six Sigma Green belt project.
Successfully ported Schindler’s Mobilinx application from the current Windows NT 3.51 based Symbol devices to Intermac's 700 Pocket PC based devices. The application was ported from VB4/Access 2 to VBCE/SQLCE platform.
Preparing & presenting the monthly SLA review to GE App Lead.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship