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.