SUMMARY

• Oracle 11g 12c, 19c Certified Professional (OCP)
• Certified Scaled Agile Framework Scaled Agile (SA), Product Owner/ Manager (POPM), Release Train Engineer (RTE)
• 25 years of IT industry experience working as Senior Database Administrator.
• 24x7 HA environment, on - call, after-hours, clustering, backup, recovery, security, performance tuning and analysis.
• Application and database architecture, design, development, implementation, troubleshooting, SDLC, and monitoring.
• Administration positively affected the revenue growth, data integrity, process streamlining, and service delivery.
• Management of the PL/SQL developers, testing, QA, and production, billing systems, 5TB+ data, 100+ colocation databases, 1000+ concurrent connections, 5mil+ users.
• Vendor contracts and SLA’s, documentation, disaster recovery, support.
• Highly motivated toward professional development and advancement, effective working independently or with a team.
• Citizen of United States.

TECHNICAL SKILLS

Databases: Oracle 8i, 9i, 10g, 11gR2, 12c, 19c SQL SERVER 6, 7, 2000, 2005, 2008 R2

DBA Tools: Oracle Infrastructure, Oracle Cloud Control, SQL SERVER Enterprise Manager, Studio, TOAD

Data Modeling: Erwin, Oracle Designer.

OS: Sun Solaris 7, 9,10, Windows 2003, 2008 R2, HPUX, Linux Red Hat, 6.2, 7.3, 8

Availability: MS Cluster, Replication, Mirroring, Oracle RAC, Data Guard, Streaming, Golden Gate

Programming: SQL, PL/SQL, UNIX, Linux shell (bash, Bourne, csh, ksh) Windows PowerShell

Storage: EMC Symmetric DMX 1000 SAN, NetApp FAS6000, Hitachi AMS1000

Hardware: Sun Fire T2000, T1000, V1280, E420r, Power Edge 6600 (test, dev, production, QA, and staging)

Applications: J2EE, JBE, XML, HTML, DHTML, VB, .Net, Tomcat

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator II

Responsibilities:

• Manage Oracle 11g R2, 12c, and 19c
• Install, configure Oracle RDBMS 9,10,11g,19c
• Administration of Tomcat ver 6,7,8,9
• Perform database Tuning, monitoring 24x7
• Monitor Jobs and schedule for SQL Server/Oracle
• Work with developers and business owner on their software
• Tune and optimize Oracle databases
• Backup/ Restore procedure
• Implement new strategy for new data growth
• Experience with Unix, and Linux OS, Storage
• Resolve any incoming incidents system
• Certified Scaled Agile frame work SA, POPM, RTE

Confidential

Sr.Oracle DBA contract

Responsibilities:

• Install upgrade Oracle 11g R2, and 10g Grid Control
• Manage 250 Oracle Instances Linux Redhat and Unix
• Creates capacity plan for all production databases and document for future growth.
• Setup Backup/Recovery Plan
• Writes Unix, Linux shell scripts.
• Build, configure and deploy SQL Databases and Systems
• Development and Oversight of backup strategies for the SQL Server Infrastructure
• Setup and Manage of SQL Reporting Services
• Configuration and Setup of Dashboard solutions for SQL based infrastructure

Confidential

SENIOR Oracle DBA

Responsibilities:

• Installs, upgrades Oracle 11g cloud computing Infrastructure, 11g RAC on a 3 node clusters with ASM.
• Install Oracle 10g, 11gR2 on VMware Sphere 5 Enterprise, and migrate to ESX.
• Setup OEM Grid Control.
• Setup data guard, Replication (Streaming, Golden Gate) for DR
• Supports Vendors system for backup/restore.
• Perform Database Clone for Development and QA
• Migrate, convert databases from Unix platform to Linux
• Performs proactive tuning for OLTP, DDS system. And health check OS, network, and Storage.
• Partitioning large table, and indices.
• Creates capacity plan for all production databases and document for future growth.
• Setup Backup/Recovery Plan
• Writes Unix, Linux shell scripts.
• Writes PLSQL, SQL procedures.
• Build, configure and deploy SQL Databases and Systems
• Development and Oversight of backup strategies for the SQL Server Infrastructure
• Setup and Manage of SQL Reporting Services
• Configuration and Setup of Dashboard solutions for SQL based infrastructure
• Create Ad Hoc Reporting
• Coordinate patch management processes for all Database Servers
• Manage SQL Database Security
• Build, configure, and deploy Windows SQL Server clusters
• Document and maintain build documents for all Database Server builds and configurations
• Maintain the product service catalog, lifecycle management and related documentation
• Establish and maintain Microsoft SQL Database architecture best practices, including procedures, guides, templates, and relevant documentation
• Work closely with business and IT associates, and outside vendors to effectively choose, plan, deploy and maintain system changes
• Provide 24x7 support of the SQL environment, including on call support
• Provide day-to-day support, guidance, and mentoring to team members
• Perform other duties as assigned.

Confidential

SR. ORACLE DBA\SQL SERVER

Responsibilities:

• Installed, upgraded, and patched Oracle 8i, 9i.
• Installed hot standby DB.
• Installed 3 remote 9i replications.
• Created materialized view, and views.
• Performed proactive tuning for OLTP, health check OS, network, and file system.
• Performed daily run of stat packs monitoring report to check stats of the DB.
• Performed partitioning and parallel executions of the database with Oracle best practice.
• Performed database refreshes upon request for development and testing users.
• Created capacity profile plan for every database and document logs for future growth.
• Designed backup and recovery plan strategy utilizing RMAN, and create snapshot/snaprestore of volume for data warehouse.
• Wrote Unix, Linux shell, scripts.
• Ensured data security and integrity by encrypting sensitive information enforce password authentication, OS hardening and applying Oracle security patches.
• Experience monitoring and optimizing the performance of ad hoc queries, *canned* reports.
• Install, patch and configure SQL SERVER 2000
• Create DTS packages
• Setup Backup and restore procedures
• Setup DR sites Standby database with log shipping, and replication on a remote servers
• Setup monitoring and health check for all the databases via ORION application

Confidential

SERNIOR DATABASE ADMINISTRATOR

Responsibilities:

• Manage a combination of 85 Oracle and SQl SERVER
• Install, patch and configure SQL SERVER 2000
• Create DTS packages
• Setup Backup and restore procedures
• Created Oracle Databases for dev, test, QA and production, administer schemas, and users.
• Performed Advance Replication, and snapshots in a distributed environment, partitioning tables and indexes.
• Managed logical and physical storage, performance tuning according to system documentations
• Tune data design, application design by fine-tuning index design, sequence generator, and clustering.
• Wrote effective SQL statement, created selective indexes as necessary, fine tune Oracle memory structure init.ora.
• Added hints to SQL queries, analyzed database objects such as tables and indexes on a regular base.
• Collected Oracle stats, Cron on UNIX Kernel stats, check for swaps space, disk I/O, memory requirements.
• Analyzed work in programming and systems analysis for microcomputer information medium systems projects in the Project Management Division.
• Worked on broader and more complex projects, effectively interfaced with technical and non-technical staff.

Confidential

SQL SERVER\ORACLE DBA

Responsibilities:

• Create DTS packages
• Setup Backup and restore procedure
• Setup DR sites Standby database with log shipping, and replication on a remote servers
• Setup monitoring and health check for all the databases via ORION application
• Setup all users and their role
• Worked on 2 projects database conversion and integrate SQL SERVER to Oracle DB.
• Coordinate patch management processes for all Database Servers
• Manage SQL Database Security
• Build, configure, and deploy Windows SQL Server clusters
• Document and maintain build documents for all Database Server builds and configurations
• Maintain the product service catalog, lifecycle management and related documentation
• Establish and maintain Microsoft SQL Database architecture best practices, including procedures, guides, templates, and relevant documentation
• Work closely with business and IT associates, and outside vendors to effectively choose, plan, deploy and maintain system changes
• Install patch Oracle 8i Database
• Create Oracle hotbackup/restore procedures
• Performed testing for data validation. After full data conversion process completed to primary production database.
• Designed and configured Oracle on UNIX and Linux environment for testing, and staging environments.
• Designed and configured Stand-by database and created hot-backup procedure for high availability operation.
• Backed up to tape media, implemented shell scripts UNIX scripts to perform database maintenance.
• Analyzed database objects, archive purging, set up cron- jobs alerts for database events.
• Performed full optimization and analyzed statistics on SGA memory, disk layout, recommended hardware for upgrades.
• Created partition on tables that had heavy access. Performance migrated, upgraded and applied Oracle patches.
• Wrote procedures, triggers packages and assisted developers with the codes to minimize query reparsing or reloading.
• Assisted developers write PL/SQL blocks then single query access the database tables which interacted with the IT management.

Confidential

Sqlserver\oracle DBA

Responsibilities:

• Managed two environments Oracle 8 and SQL server 6. Installed Oracle 8 versions on UNIX (Solaris and Linux).
• Managed 100 users, database security, installed, configured SQL server 6.5 database on Windows NT.
• Create backup\restore methods for Oracle and SQL SERVER databases
• Utilized SQL Enterprise Manager to manage users, objects, schedule events, and performed DBA administration tasks.
• Monitored activities in real time, traced SQL statements and RPC, wrote DTS packages, and store procedures.
• Performed MS Query tool which allowed users to graphically build queries against any ODBC data source.
• Analyzed and made recommendations for solution of variety of operations.
• Direct and indirect reports which included developers, operations, test, and QA.