SUMMARY:

• Information Technology professional with demonstrated s in database
• Administration using a variety of technologies and platforms. An analytical and intuitive problem solver, who learns quickly and possesses a strong desire to succeed. Expertise is broad in scope and includes the following:
• Over 18 years of experience as a MS SQL Server 7 - 2016 administrator in a variety of environments like Windows Server .
• Planning, Installing and configuring SQL on Windows Server,
• Cluster Environment.
• Planning and Implementation of SQL Server transactional replication technology.
• Experience with Log Shipping.
• Extensive experience in database administration, backup, recovery, performance tuning.
• Extensive experience in database analysis, design, testing and implementation of OLTP
• Systems including Hybrid and DSS databases.
• Experience in handling large databases over 5 TB, in production environments.
• 6 years of experience in writing complex T-SQL statements for different queries, creating tables, indexes, constraints, functions, stored procedures, triggers, views.
• Excellent communication skills, team player, ability to work individually and meet deadlines.
• Writing test cases.

TECHNICAL SKILLS:

PLATFORMS: Pentium based LAN

OS: Windows Server 2008/2012/ Windows 7/8.1/10, Ms-Dos/Linux

DBMS/RDBMS: MS SQL Server 7.0 -2016, MS Access/SQLite,PostgresSQL

TOOLS: SQL SERVER: SQL, T-SQL, DTS, BCP, OPEN CLIENT/DB LIBRARY ERWIN/ERX 2.5, Visio, MOM, PERF MOM, SYS MOM

OTHER TOOLS: SQL Diagnostic Manager, Litespeed, SQL Profiler, DevtrackMicrosoft Visual Source Safe, SQL Safe, NetIQ, Redgate, Idera SQL AdminToolSet,SQL sentry,SQL lite

SOFTWARE: RapidSQLREPORT WRITER: Crystal Reports 8.5, 9,10,11,11.5,12

PROFESSIONAL EXPERIENCE:

Confidential, GA

Senior SQL Server DBA

Responsibilities:

• Installed, configured and tested SQL on windows R2 cluster environment.
• Configured Log Shipping in SQL database servers.
• Side by side migration of SQL in Development and QA databases.
• Configured, Managed, Support Development, QA and Production databases.
• Provided on call support.
• Maintained SSIS packages for data extraction, transformation & load.
• Scripting database tasks and storing in Microsoft Visual Source Safe for version control.
• Production Support DBA role.
• Responsible for Code migration from Development to QA / Production environments.
• Configure, resolve backup / restore failures.
• Analyze and monitor space usage and Database growth in all environments.
• Provide monthly metrics reporting to upper management.

Confidential, GA

Senior SQL Server DBA

Responsibilities:

• Responsible for maintaining production/ test/development databases.
• Performing database backups, recoveries, loads, consistency checks and conversions.
• Manage, troubleshoot, configure and test SQL cluster environment.
• Designed and Implemented Security Policy; Managed security through
• Application Roles, assigning the appropriate privileges to roles; Created views and stored procedures for additional security.
• Create and manage Indexes and statistics.
• Design the Database Backup and Disaster Recovery strategies via Warm
• Backups & Hot Backups and also recovery up to Point of Failure.
• Automate the maintenance of standby servers by using log shipping.
• Monitor database performance at System level, SQL server Level & Database level using windows counters, SQL Performance Monitor and SQL Profiler.
• Analyzing, isolating and resolving any database failures.
• Develop logical and physical database design.
• Analyze space usage and fragmentation to optimize space utilization and performance.
• Designed/wrote inventory tracking, data analysis, and statistical reporting applications for upper management.
• Define operators, implement jobs, and configure alerts to automate everyday administrative tasks.
• Install, configure and maintain SQL
• Upgrade SQL Server 2012 installation to SQL Server 2016
• Upgrade SQL Server 2000 installation to SQL Server 2005
• Code Migration from Development to QA / production environments.
• Conduct monthly maintenance tasks.

Confidential, GA

SQL Server DBA

Responsibilities:

• Installed, configured and tested SQL 2000 on windows 2003 cluster environment.
• Configured Log Shipping in SQL 2000 database servers.
• Side by side migration of SQL in Development and QA databases.
• Configured, Managed, Support Development, QA and Production databases.
• Provided on call support.
• Maintained DTS packages for data extraction, transformation & load.
• Scripting database tasks and storing in Microsoft Visual Source Safe for version control.
• Production Support DBA role.
• Responsible for Code migration from Development to QA / Production environments.
• Configure, resolve backup / restore failures.
• Analyze and monitor space usage and Database growth in all environments.
• Provide monthly metrics reporting to upper management.

Confidential, GA

SQL Server DBA

Responsibilities:

• SQL 2000/2005 Cluster analysis and reviews. Troubleshoot SQL Cluster failures.
• Performance analysis of SQL databases and recommend performance tuning strategy.
• Installed and configured SQL 2005 on windows 2003 in cluster environment in test labs.
• Side by side migration of SQL .
• Configured & maintained replication between SQL 2005 & 2000 servers.
• Planning, Installing and configuring the SQL 2000 on Win 2003 in Cluster Environment.
• Configured SQL Health reports to monitor the health / inventory of SQL server hardware and software.
• Designing the Database Backup and recovery strategy and Warm Backup strategy i.e. log shipping.
• Installed, configured MOM for SQL monitoring.
• Provided on call support.
• Served as the primary Resource for SQL Server developers.

Confidential, Chicago, IL

SQL Server DBA

Responsibilities:

• Migrating from SQL 7.0 to SQL 2000; managing multiple instances.
• Designing the Database Backup and recovery strategy and Warm Backup strategy (log shipping).
• Providing Strategic vision for company’s database systems.
• Envisioned, designed and implemented SQL server scaling out from single point of processing.
• Ensure network and data security through access protocols, application roles, views & schema management.
• Installed & configured SQL Server Reporting Services
• Configured SQL Health reports to monitor the health / inventory of SQL server hardware and software.
• Developed Data models using Erwin.
• Worked with Product Development Team to design new data models and extend existing models.
• Automating the jobs, defining alerts and operators.
• Enforcing Database integrity using both Procedural integrity through Stored
• Procedures, Triggers and Constraints.
• Created and maintained DTS packages for data extraction, transformation & load.
• Monitor database performance to evaluate availability and reliability.
• Configured and maintained EMC CX300 San for production and QA environments.
• Installed, configured MOM for SQL monitoring.
• Provided on call support.