SUMMARY:

• 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 wif 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 wif strong leadership skills.
• 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

Tools: SQL Server (on Premise and cloud) 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000 | Sybase | Oracle| Progress| MySQL in Cloud| MONGO DBErwin, 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 SQL, PL/SQL, ASP.NET, VB.NET, HTML, XML, Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential

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 to other team members.
• Maintain documentation of the database environment and infrastructure.
• Work wif system administrators, architects, development teams, and business application owners to ensure database changes are in-line wif operational standards and the strategies needed to scale.Work collaboratively wif 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 wif 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

Sr. lead DBA/Consultant

Confidential, Houston, TX

Responsibilities:

• 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

Responsibilities:

• 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 wif functional and load tests.

SQL Server DBA/Developer

Confidential

Responsibilities:

• Worked wif 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 wifin 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.

SQL & Sybase Server DBA/ Developer

Confidential

Responsibilities:

• Managed very complex databases wif multiple sites and huge dealer network. 25 company installations and over 1000 dealer client modules wif Sybase, MS-SQL, Reports & FoxPro DBMS.