SUMMARY:

• Professional with over 17 years’ experience in IT as an Confidential Database Administrator (9i, 10g,11g & 12c) and SQL Server DBA. An in - depth knowledge with Real Application Cluster (RAC), Automatic Storage Management (ASM), Confidential Enterprise Manager (Grid control) and AWS.
• An extensive background providing technical assistance to developers and end-users to resolve functional errors, prevent down-time, create scripts, research and apply patches to fix bugs, as well as resolving database performance and capacity issues.
• Well versed in all database Administration roles including capacity planning, configuration of databases, performance tuning, database upgrades and security policy implementation, data replication, application clustering, detail oriented as well as exemplified analytical and problem-solving skills.

TECHNICAL SKILLS:

RDBMS: Confidential Version 8i/9i/10.x/11.x, 12c, SQL Server 2005/2008, MySQL

APPLICATIONS: Confidential Financials. 11i (11.5.10), Web Logic, TIMMS, Quality Center & MAXIMO

UNIX OS: Sun Solaris OS 8, 9 & 10. Red Hat Linux 0S 5.2/6.2/7.0 S4, HP-UX 11x

UNIX Hardware: Sun E450, Sun T540, HP 9000, Windows Server 2000, 2008 Confidential X2/X3/X4 full rack Exadata machine

LANGUAGE: PL/SQL, SQL, C++, C, Perl scripting.Python, Vi.

Platform/Applications: Confidential Enterprise Manager (Grid Control) 10, 11,12c Confidential Real Application Cluster (RAC), AWS, Confidential Middleware technologies ( Confidential WebLogic), Identity Manager, Business Intelligence, SOA Suits. RMAN, TOAD 10.6, Erwin, Golden Gate 11g, OBIEE 11g, Confidential SQL Developer (3.0.04), (HP) Quality Center, Microsoft SharePoint 2012, GitHub & ServiceNow, BMC Remedy Tool Suite, Visio, LeanKit & Jenkins

Cloud/Virtualization Computing: Amazon Web Services (AWS)- S3, Amazon EC2, Redshift, Cloud Watch & Cloud Trail, Confidential VM Manager, Confidential Virtual Server, NFS Server/ Server Pool.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Lead Database Consultant

Responsibilities:

• Installed 12c Confidential Real Application Cluster (RAC) including configuring Confidential Enterprise Linux for RAC.
• Assisted in developing consistent distributed databases by using shading and replication on AWS platform.
• Assisting with the AWS Cloud readiness effort.
• Involved in design and implement Confidential high availability features, such as data guard and RAC.
• Performed daily maintenance tasks and troubleshot any issues related to data guard and RAC.
• Utilized Confidential utilities such as AWR, ADDM and ASH reports for Database, Systems and Application tuning.
• Enforced database security strategies by creating database users, user roles, profiles, audit trails, audit banners and transparent data encryption
• Develop disaster recovery, maintenance, data integrity, capacity planning and performance tuning strategies and standards for databases to meet business objectives
• Database storage requirement analysis and capacity planning.

Confidential, Washington, DC

Deputy Confidential Database Manager

Responsibilities:

• Involved in applying Confidential security patches and critical security updates to Confidential databases.
• Experienced in upgrading and migration of Confidential Databases from 11.2.0.4 to 12c (12.2.0.2).
• Created Cloud Formation Template for main services including EC2, VPC and S3 for reuse the current environment.
• Installation and configuration of Confidential Enterprise Manager Cloud Control 12c, worked extensively on 12c OEM and configured DB alerts for DBA’s.
• Monitoring Templates and Incident Rule notifications using OEM 12C for database alerting
• Configuration and upgrading to 12c with Physical/Logical Standby and Administration of Active Data Guard 11g/12c environments.
• Implementation of high availability solutions with Confidential 11g RAC, Physical and Logical Standby database (Data Guard), Materialized views, Replication and Golden Gate.
• Created and setup Confidential databases 12c, created Container database and Pluggable databases.
• Involved in configuring and maintaining the Real Application Clusters RAC with ASM on three nodes and four nodes for high scalability and availability both 11g/12c.
• Experience and administration of Golden Gate and upgrade from 11g to 12c
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Migrations, patches, performance tuning, backup and recovery, cloning, space Management, database security, auditing.
• Strong experience in Backup and Recovery strategies using RMAN 11g/12c, Export/Import, Data pump, Hot and Cold backups.
• Involved in the maintenance and administration of Confidential database in DEV, STAGE and PROD environments.
• Installed Confidential Clusterware to provide infrastructure for RAC and configured 3 node Confidential 11g.

Confidential, Washington, DC

Lead Database Consultant

Responsibilities:

• Senior consultant providing managerial and lead responsibilities on customer proprietary projects including database administration and upgrades as well as user interface support.
• Managed and coordinated the upgrades of 50 Confidential databases from lower versions to a release 11.2.
• Tablespace and associated index reorganization in database to avoid tablespace management issues. Created custom monitoring and forecast reports from 11g Grid Control.
• Performed and oversaw Confidential database upgrades of over 120 databases from lower level.

Confidential, Columbia, MD

Lead DBA/Task Manager

Responsibilities:

• Manager/Lead DBA to a team of 14 DBAs and managing over 60 Confidential development and test databases. Serve as a central point of contact in providing daily database related managerial and technical support to Confidential ’s Development Effort Consolidated Contract ( Confidential ).
• Managed database projects, develops and directed technical project teams through all phases and activities of the project management life-cycle process that are essential to Confidential goals that affect operations on a long-term and continuing basis.
• Determined database project goals and priorities with management, program director and release managers. Managed and communicated a clear vision of the project's objectives and motivates the cross functional project team to create a project environment that enables peak performance by the entire team.
• Managed resource assignments and tracking to the project plan and project schedule in coordination with the line of business resource managers.
• Coached to clarify assignments and deliverables; mentors’ others in project management practices; reviews quality of work and manages the integration of team members’ work.
• Manages resource assignments and tracking to the project plan and project schedule in coordination with the line of business resource managers.
• Experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine.
• Assisted in installation, assembly and patching of Exadata and Confidential applications

Confidential, Arlington, VA

Application & System DBA

Responsibilities:

• Created, configured and resolved Linked Servers issues on both Confidential and SQL databases.
• Installed cloned, partition and hardened Sun SPARC server for disaster recovery purposes.
• Maintained, monitored the health check of three Confidential databases on Sun SPARC.
• SQL server databases on Dell Power Edge Server 2650.
• Involved in implementation and testing of Confidential Applications Financial R11 GL, AP, PO and FA modules.
• Proactively assisted users with Confidential Financial implementation (PO, AP, GL and FA modules) and resolving functional errors.
• A good understanding of integration of Confidential Applications modules, Chart of Accounts and Flex fields.
• Application tuning; Monitored application key table spaces and error logs to prevent down-time, run bug scripts, researched and applied Confidential patches to fix bugs.
• Support in the conversion of proprietor application from MEI to TIMMS.
• Created scripts to run back-up and verify Confidential instance daily. Assisted developers and web administrators in the design, modification of stored procedures and packages.

Environment: Confidential 11.5.4, 11.5.10, Confidential 8.1.7 on Solaris OS 5.6, Confidential 9i &10g on Red Hat Linux Enterprise 4, SQL Server 2000/2005.

Confidential, Richmond, VA

Application DBA ( Confidential DBA)

Responsibilities:

• Providing technical assistance up to 13 development and production databases (sz: 100 GB - 1 TB) for Capital One fraud detection and Customer Relations department.
• Application tunning ensuring third party compliance, database health checks to monitor table and table space anomalies. Resolve database performance and capacity issues.
• Table and associated index reorganization in databases to avoid row chaining and table space management issues.
• Member of Capital One Enterprise Information Management team enforcing proprietary security procedures for specific user applications.
• Performed Performance Tuning - proactively monitoring memory, queries, space-usage, I/Os, latches for bottlenecks and taking quick corrective measures.
• Physical and logical designing of the database, defining and tuning DML and DDL related statements with project team developers

Environment: Confidential 8.1.7, 9.2.1 Partition and Parallel Server on UNIX HP-UX 11.x

Confidential, San Mateo, CA

Technical Consultant

Responsibilities:

• Support the development of Postal Public Key Infrastructure (PPKI) through Cylink application.
• Installing and supporting Confidential versions on Unix Sun Solaris platforms to enable users to an e-commerce transaction.
• Assisting developers enhance codes to comply with restrictions and constraints.
• Worked with team of technical developers supporting SQL Server 7.0 (120 GB) databases on WIN 2000 operating platform. Benchmarking studies in support of the IT senior Leadership team.
• Execute UNIX Perl Scripting to monitor scheduled jobs and send email alerts to DBA’s.
• Implement effective cold / hot backup and recovery procedures to provide data availability.
• Involved in Business Continuity Plan (BCP), Disaster Recovery Planning (DRP), logistics and implementation of recovery procedures to restore critical business functions.
• Setting up staging two 120 GB Confidential databases for application testing.

Environment: Confidential 7.3.4, 8.0.4, 8.0.5, 8.1.7. UNIX Sun Solaris 2.6, 5.8