PROFILE:

• Dedicated, focused, results driven professional with broad - based experience in database administration, metrics improvement, system support and leadership
• Over 19 years of experience in database, analysis, planning, design, implementation, troubleshooting, documentation of IT projects, database applications, and third-party solutions, in support of customer requirements and the organization’s business needs.
• Combine premeditated planning, budgeting and team development expertise with strong technical qualifications.
• To contribute to the company’s growth strategy by leveraging my strong personal and technical skills to increase performance and productivity while promoting teamwork, communication, and service excellence.
• Goal oriented with strong leadership skills.
• Seasoned IT professional with extensive experience in MS SQL Server, MYSQL, MONGO, SYBASE and ORACLE.

• Highly skilled in the support of large enterprise infrastructure including installations, upgrades, performance monitoring and tuning, disaster recovery, standards and documentation.
• Personable, senior technical team lead, with excellent verbal and writing skills. Effective leadership skills.
• Trilingual in English, Hindi and Telugu, verbal and written.

AREAS OF EXPERIENCE:

Always on AG| Database Mirroring |Replication |Clustering |Database Log Shipping| Performance Tuning| Disaster Recovery| DTS | SSIS| SSRS| SSAS| System Analysis| Database configuration, design, development, Security and Implementation| Capacity planning | Management Data Warehouse | SQL Performance Dashboard | PAL Tool | SQL Nexus |ERP applications such as PeopleSoft, Siebel

TECHNICAL SKILLS:

Business Domains: Cruise Industry, Healthcare, Manufacturing, Entertainment, Software

BI: SQL Server (on Premise and cloud) 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000 | Sybase | Oracle| Progress| MySQL in Cloud| MONGO DB Erwin, Visio

SSAS, SSIS, SSRS, DTS, Oracle Import/Export: Splunk, Manage Engine, App Dynamics, Solarwinds, Netbackup, VRanger, VMWare, Precise, DBArtisan, ERStudio, ERWIN, SharePoint, Team Foundation Server (TFS), Visual Studio, ISSDM - Change Mgmt., Service Now(SNAP), HEAT, CLARIFY, Idera Diagnostic Manager, Litespeed

Applications: PeopleSoft, Tuxedo

Reporting Tools: Crystal Enterprise, MS Reporting Service, Brio reporting

Operating Systems: Windows, Unix, Linux

Languages: T-SQL, PL/SQL, ASP.NET, VB.NET, HTML, XML, Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential, FLORIDA

Senior Technical Lead DevOps DBA| Architect | Developer |Project Manager

Responsibilities:

• Install, configure, upgrade, patch, and manage Microsoft SQL (Versions 2005 to MSSQL2016) and Oracle (10p, 11g, 12c) production/Dev/Test servers.
• Establish and maintain backup and recovery policy and procedures for local and cloud databases.
• Provide proactive monitoring and performance tuning including physical server level, database level, and query tuning.
• Setup clusters/always on/replication/database mirroring/log shipping/Disaster Recovery setups for production systems.
• Create users and assign permissions based on authorized level of access.
• Provide SME-level representation for DBA team to account leadership, clients, application owners, and infrastructure teams.
• Create monitoring alerts for Always on/Cluster failover and failbacks, alerts for SQL job failures etc.
• Implement production standards, policies. Provide guidance to the DBA team to follow operational best practices and perform load tests for critical business/revenue impacted systems.
• Ensure 24/7 availability of the SQL and Oracle Server database environment.
• This will include 24/7 on-call responsibilities on a rotating schedule. Represent SQL and Oracle Server Database Administration team in Disaster Recovery and project activities.
• Share technical expertise providing technical mentorship and cross training to other team members.
• Maintain documentation of the database environment and infrastructure.
• Work with system administrators, architects, development teams, and business application owners to ensure database changes are in-line with operational standards and the strategies needed to scale.Work collaboratively with cross-functional teams to administer as well as troubleshoot live issues both internal as well as customer reported.
• Create operational documents and prepare SLAs. Work closely with business and development teams.
• Advise and implement Disaster recovery procedures to critical servers.
• Involve in production performance tuning/troubleshooting issues and provide production systems outage root cause analysis.
• Create production backup maintenance plans and apply latest SQL service packs as well as new SQL server installations, configurations and existing old SQL versions upgrades, Consolidations etc.

Confidential, Miami, FL

Senior Technical Lead SQL DevOps DBA| Architect | Developer |Project Manager

Responsibilities:

• Coordinate new version upgrades for SQL servers, database implementations and enhancements for the existing/upcoming applications.
• Experienced in cluster, always on, replication, mirroring, log shipping and Management Data Warehouse setups and providing Disaster Recovery solutions.
• Perform capacity planning, server replacements, upgrades, and database migrations
• Create logical and physical data models, data flow diagrams, and data dictionary documents
• Plan and apply Microsoft security hot fixes, and service packs to avoid potential vulnerabilities
• Design Extract-Transform-Load processes using SSIS for data imports, exports, and migrations.
• Install and configure databases on centralized, virtual, physical, and clustered environments.
• Manage new projects, delegate tasks to team members and monitor for accuracy and timely completion of assignments. Mentor and train team members on best practices.
• Document procedures for service level agreement (SLA), disaster recovery testing, database installation standards, and database security, and infrastructure maintenance.
• Participate in 24x7 on-call rotation and respond to critical issues
• Support for MS SQL 6.5, 7.0, 2000, 2005, 2008, 2008 R2, 2012, 2014 and 2016 versions. Production support for Clustered and non-Clustered environments shore side and ship board.

Sr. lead DBA/Consultant

Confidential, Houston, TX

Responsibilities:

• Responsible for the support of 150+ SQL Server and Oracle installations hosting mission critical business and clinical databases.
• Managed transactional data replication to geographically dispersed sites.
• Planned and implemented disaster recovery solutions for all production databases.
• Planned capacity for database servers. Ensured high throughput of transactions via ongoing database tuning. Researched and resolved data processing issues including blockings and waits.
• Installed and upgraded SQL Server instances in dedicated and clustered environments.
• Applied service packs, cumulative updates and security hot fixes as required.
• Redesigned and optimized backup, restore, and indexing strategy to reduce system downtime.
• Provided 24x7 on-call support for mission critical databases.

SQL Server/Sybase DBA

Confidential, Danbury, CT

Responsibilities:

• Ensured availability, security and integrity of 800+ databases hosted across the globe, on 124 servers including 20+ clustered environments.
• Captured performance baselines and analyzed query execution trends. This resulted in well-tuned queries which improved overall performance by 30 percent on several servers.
• Installed and configured SQL Server and BI components. Created server build documents to maintain consistency across all environments.
• Implemented maintenance plans for database backups, reindexes, and integrity checks.
• Created disaster recovery procedures and participated in annual disaster recovery testing.
• Created Data Transformation packages for data feeds across heterogeneous database platforms
• Contributed to the creation of a DBA Handbook to document routine processes and procedures.
• Assisted Quality Assurance engineers with functional and load tests.

SQL Server DBA/Developer

Confidential

Responsibilities:

• Developed logical and physical data models for Accounts payable and Accounts receivable systems.
• Installed, configured and supported SQL Server 6.5 and Sybase databases instances to host application data.
• Worked with end users to identify business needs and create requirements document.
• Created and maintained logical and physical data models using ERWIN. Reversed engineered existing databases to uncover logical relationships within schema for data reporting purposes.
• Performed database backups and restores, data imports/exports and daily maintenance
• Installed database software, created database objects, administered user security, monitored query performance and tuned slow-running queries.