SUMMARY:

• Highly motivated team player, adapt at multi - tasking and thrives in a fast paced environment, proficient in prioritizing, completing projects and assigned tasks in accordance with budget and time schedule, yet flexible to multitask when necessary.
• I have over 5 years track record of experience in SQL Server database administration in core enterprise and corporate environment.
• Experience with implementation of disaster recovery (DR) and High Availability (HA) strategy planning with Clustering, Mirroring, Log Shipping and Replication.
• Experience with setup and administration of SQL Server Database Security environments using Profiles, database Privileges and Roles.
• Provide SQL Server database physical model creation and implementation (data type, indexing, ER, Normalization and table design).
• Monitored database server performance and if required go for tuning of the TSQL queries, Stored procedures etc.
• Use various 3rd party tools like Quest Lite-speed, Redgate, and Fog light for database backups and T-SQL tuning and monitoring.
• Working knowledge in creating SSIS packages to automate Import and Export of data to and from SQL Server using ETL tools.
• Configure and support SSIS and SSRS for SQL Server 2005, SQL Server 2008 R2 and SQL Server 2012.
• Complied with standard security-related procedures that are based on established best practices and conformity to company policy.
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery, managing windows clusters and SQL servers
• Experience with database upgrades and applying service packs
• Experience in creating, monitoring, backup, recovery, and tuning SQL Server databases in a multi-platform environment.
• Develop and document SQL coding guidelines for SQL Server 2005, SQL Server 2008 R2 and SQL Server 2012.
• Experience in DR processes including Log Shipping and Database Mirroring.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Experience in Production support of 186+ (SQL Server 2008, 2008R2, and 2012) instances running on Windows 2008r2/2012r2 Servers.
• Experience in monitoring and troubleshooting 24x7 operations and providing on call services to clients.
• Experience in PowerShell Automation.
• Experience in using SQL Server Profiler, SQL Server Agent, Resource Governor and Database Engine Tuning Advisor (DTA).
• Experience in supporting Very Large databases (VLDB) and troubleshooting related problems.
• Handling Memory configurations for SQL Server 2012 and SQL Server 2008R2 on various windows version

TECHNICAL SKILLS:

RDBMS: SQL 2005, SQL 2008, SQL 2008R2, SQL 2012, SQL 2014 and SQL 2016

OPERATING SYSTEM: Windows 2000, Windows 2003,Windows 2008R2, Windows 2012R2 and Windows 2016

PROFESSIONAL EXPERIENCE:

Confidential

Consultant SQL Server DBA

Responsibilities:

• Performs SQL SERVER database upgrades from version 2005 and 2008R2 to 2012/2014 also applied patches to 2005 and 2008R2 database server instance.
• Provide recommendation and standard best practice to project team on related SQL task.
• Work with developers and application team to implement databases from design and build perspective to test-cases and UAT all the way to production go-live for onboarding new application or enhancing existing application.
• Configured and implemented robust HADR solution with SQL 2012 and SQL 2014 Always AG cluster to me business SLAs for RPO and RTO in achieving Business Continuity Strategies.
• Working on configuring SQL Server with minimum privileged access
• Using SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code
• Assists in providing documentation detailing the design and architecture of the databases, as well as the administration, backup procedures and data recovery steps.
• Working with other DBA's in the recovery of corrupted databases, timely troubleshooting of all database-related problems and emergency response to all production downtime events.
• Working with transactional replication in a many to many relationship from application platforms to development to production, fixing primary key issues, latency and block issues.
• Assisting end users to define, implement, and maintain their reporting requirements.
• Assisting in promotion of database related changes from development to production.
• Experience in writing, evaluating and optimizing complex SQL codes, stored procedures and scripts for maintenance and reporting purposes.
• Monitoring application and database performance, and adjusted database parameters, application code or schema as needed.
• Monitoring space usage, adjust database as needed, backup operations and performing Administrative task on SQL 2008R2/2012.
• Working on configuring SQL Server with minimum privileged access.
• Maintaining and coordinated the creation, modification and maintenance of database structures with minimal supervision.
• Assisting in developing, modifying, and optimizing complex stored procedures, and triggers to handle complex business rules, history data and audit analysis.
• Responsible for troubleshooting of application performance issues, database maintenance & configuration, patching, and upgrading.
• Participating in DBA On-call weekly/monthly rotation and documented environments and processes where applicable.
• Working with other DBAs, Developers team members and various application teams

Confidential

Consultant SQL DBA

Responsibilities:

• Performed backups of all SQL Servers as required
• Ensured security of the database servers by implementing applicable security patches and maintaining appropriate security measures.
• Reviewed Developers SQL code for security, standards and optimization.
• Provided recommendations to Developers outlining alternate methods of accomplishing the same tasks.
• Monitored and maintained database performance and identified/recommended areas that can be improved.
• Managed and executed maintenance jobs that ensured the stability and performance of the database servers.
• Performed Administration tasks on SQL Server 2005 (replication, tuning, configuration, troubleshooting
• Established and enforced controls to ensure database integrity.
• Installed, configured, and administer Microsoft SQL database instance
• Created and/or maintain clear documentation regarding all components of database administration
• Worked with a team of 6 other Database Administrators, 4developers and 3 application vendor consultants to ensure quality deliverables to our client.
• Proactively monitored, identified, isolated and resolved server problems to avoid impact on the business.
• Ensured all servers related trouble tickets are handled appropriately.
• Coordinated with platform hosting vendor(s) DBAs to ensure proper support, maintenance, and tuning of various databases
• Developed and maintained ETL scripts for efficiently loading and extracting data from the database when necessary.
• Developed, tested, and maintained a backup and recovery process to ensure proper system continuity in the case of an unforeseen event.
• Implemented production changes working with ITIL process and required application downtime.
• Work to support production with day to day database and system incident resolution without breaching ticket SLAs.
• Worked with offshore support team to ensure 24/7 coverage with excellent shift handover notes and communication among the team.

Confidential

Technical UAT Specialist / Quality Assurance

Responsibilities:

• Develop meaningful relationships with existing and new customers
• Facilitate sales support to corporate offices by focusing on specific products
• Develop and implement business sales strategies aimed at profitability
• Hire and train sales personnel and deploy them to regional offices
• Develop and strengthen relationships with customer service personnel
• Execute sales expansion strategies
• Build and maintain prospective accounts lists
• Facilitate sales and service support to different regions
• Develop and present business plans for approval from management