SUMMARY:

• Provide technical and architectural solutions for database projects e.g. New provisioning, major and minor version upgrades, cross platform database migrations (e.g. oracle to mssql), security compliance, Virtualization etc.
• Responsible for managing and supporting Production, Development and staging instances.
• DBA and app Support for various Oracle products e.g. EBS, Apex, OBIEE, WebLogic, OEM etc .
• Refreshing the database environments as per client requirements (Rman /cloning/Data - pumps/exp-imp).
• Oracle installation, upgrade, migration of databases, backup and Recovery operation using Rman, Data pump and SSMS (SQL DB) technologies.
• Build and manage physical standby databases.
• Writing automation scripts for informing DBA’s regarding the database status, performance monitoring, housekeeping, auditing, space management, backup and refresh etc .
• Patch installations and fixing the bugs; Configure OEM 12c and agent installations.
• Experience with Database Performance Tuning, Query Optimization, Client / Server Connectivity / Network Issues
• Work with Oracle (Vendor) support to establish service back online ASAP for critical issues.
• Handling user profiles and security audit management.
• Provide technical support and assistance to all database end users.
• Provide support to 300+ SQL server database instances.
• DBA team lead for Oracle and SQL team size of 16; DBA SPOC for client; responsible to maintain work balance among team members, manage shift coverage, track individual performance, lead in technical discussion calls with client, Architect new applications for DB and app servers, handle high priority issues in the project.

TECHNICAL SKILLS:

Operating Systems :  Windows, Solaris, Linux

Ticketing tools:  HP SM7/9, BMC Remedy, Service Now

Tools Used:  Putty, Toad, SQL Developer, SQL Server Management Studio, Query Analyzer, SSRS, Veritas NetBackup, Rman, Visio, AWR, SP, SQLT, PL/SQL, OSW, WinSCP, FileZilla

Monitoring Tools used:  Foglight, Solarwinds, DynaTrace, IPMon, OEM, SCOM, OVO, automated scripts

Business Domains:  Telecom, Oil & Energy, Tax & Assurance, Government

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Lead DBA, Oracle / SQL DBA

Responsibilities:

• Architect database/application infrastructure design for new/existing applications and migrate to cloud infrastructure.
• Migrate the Oracle and SQL databases by various approaches as per need such as export import, hot cloning, Rman duplicate and cold cloning, backup and restore using SSMS.
• Support for Oracle e-Business databases, renewing SSL certificates, EBS refreshes and patching to latest PSU
• Standardize monitoring jobs, backup jobs across the enterprise for Oracle and SQL databases. Experienced in configuring and maintaining EMC DDBoost storage for Oracle Rman backups.
• Provide 24/7 support for all the databases for service requests and incidents.
• Experience with Database Performance Tuning, Query Optimization, Client / Server Connectivity / Network Issues
• Used the reporting tools
• Implement the best practices of ITIL framework in day-today support activities.
• Document uniquely faced issues and SOPs for junior DBAs in team.
• Manage the team for work balance, resolving L2/3 issues, client reporting on weekly/monthly basis for SLAs and KMs as per agreement.
• Well versed with LINUX operating system.
• Oracle license management for 200 databases and various Oracle products.
• Participate in various database proposals to provide effective solutions as per client requirements.

Confidential, Tampa FL

Sr. Oracle DBA / SQL DBA Tampa FL

Responsibilities:

• Software Installation, Database creation, cloning, patching, up-gradation & refresh activities
• Providing database support to ensure 24x7 availability for production, development and test instances, create and manage standby databases.
• Creation and management of database schema and schema objects
• Managing tablespaces, backup & recovery activities
• Database monitoring through foglight alerting tool, SQL Query Tuning, Performance Tuning, troubleshooting regular database maintenance issues
• Writing automation scripts for DB refreshes, TWS jobs, database health checks
• Customer interfacing- Participate in calls, provide weekly updates, planned activities status, own DBA related issues and track till closure.
• Managing and administering Oracle 10g and 11g databases, ensuring availability and performance of all Oracle and SQL Server databases.
• Implementation of database and data architecture monitoring technologies and procedures and proactively monitor the database systems and resources to ensure secure, stable, high-performing services with minimum downtime.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Used LINUX operating system for the process.
• Monitoring Index Fragmentation and Rebuilding the Indexes for partitioned & non partitioned tables at regular intervals to Improve Performance.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Support for performance tests of database and applications
• Prepare database performance and capacity reports.
• Oracle license management for 200 databases and various Oracle products.
• Implement the best practices of ITIL framework and document the processes.
• Participate for various database proposals and prepare HLD, LLDs.

Confidential, Broomfield, CO

Oracle DBA Broomfield, CO

Responsibilities:

• Providing production database support to ensure 24x7 availability and also support their test and development database instances as per agreed SLA
• Software Installation, Database creation, cloning, patching, database migration, up-gradation & refresh activities, ASM management, OEM installation, RAC L1 support.
• Provide geodatabase support, manage ArcSde (SDE) schema, upgrade, migrate and ArcCatalog administration.
• Provide application support to various applications such as Tibco, Siebel, Clarify, Netcool, Infovista, Informatica, Hyperion, Kennan, Arbor, 3Flow, Nums, LNP, Soprano, 3Scape, LMS, AMS, NextGen etc.
• Creation and management of database schema and schema objects, user access control.
• Managing storage space, tablespaces, backup & recovery activities
• Database monitoring using OVO tool, SQL Query Tuning, Performance Tuning, troubleshooting regular database maintenance issues
• Writing automation scripts for various monitoring alerts and database refreshes and DB health checks.
• Support application specific production deployments during monthly releases.
• Create and manage physical standby databases
• Customer interfacing, SOP document anchor, SLA management and reporting
• Support DW databases, activities included - Table partitions, partition movement from tier1 to tier2 storage, data archiving, partition index management