SUMMARY:

• Extensive knowledge with database installation, design, configuration and hardware/ software upgrade experience; administer technical applications and provide knowledgeable/ professional user support; consistently meet deadlines and project requirements.
• Recommend, create and manage automated enterprise solutions; implement and maintain system
• Security policies; provide knowledgeable end user support; troubleshoot related issues/concerns; and maintain accountability for effective interoffice system utilization, smooth day - to-day operations, and ready accessibility of data required in internal/external communications.
• Excellent writing and verbal communication skills, relates well with both abstract and conceptual theories, work well independently and/or in team oriented environments, and actively support progressive development.
• A high achiever, a quick study, logic oriented, very resourceful and a results-oriented problem solver.

TECHNICAL SKILLS:

• Oracle 10g/11g/12c Database Administration
• Oracle 12c Grid Control setup and Administration
• Oracle VM and Linux VM
• Performance Tuning & Capacity Monitoring
• Data Security, Backup & Recovery
• Standby/Failover Administration
• Oracle RAC & ASM Administration/Installation
• Oracle Forms and Reports Development
• Database-Backed Web Solutions
• SQL Tuning in an Oracle Environment
• Postgress Administration/Installation
• MySQL Administration/Installation
• AWS/RDS/EC2 database setup and administration
• Oracle Cloud
• MongoDB and DynamoDB

PROFESSIONAL EXPERIENCE:

Confidential, Lewisville, TX

• Manage and support over 300 databases on Solaris, Linux, RDS and EC2.
• Support Oracle, Postgress, and MySQL databases.
• Manage a team of 10 oracle DBAs.
• Provide RFQ’s to upper management.
• Work with software methodologies such as Agile and SCRUM.
• Work with Vendors
• Design, development, and implementation of large, complex database systems supporting one or more business and/or technology areas, including OLTP and Data Warehouse.
• Responsible for Oracle product code base, upgrades to new Oracle/Postgres/MySQL versions, development of processes and procedures.
• Evaluation of fixes, patches and security vulnerabilities for new Oracle/MySQL/Postgress version.
• Work with internal audit teams to assure SOX compliance for all applications that are supported within my team.
• Support Postgress, MySQL, DynamoDB and Oracle RDS instances within Amazon Cloud and Data Center.
• Migrated Databases/Applications to amazon RDS and EC2.

Confidential, Addison, TX

Sr. Manager, DBA

• Provide technical leadership to the Applications Support Team, Developers and System Admins.
• Support Production, QA, DEV, UAT databases
• Guided and mentored team members to support all production databases.
• Provided 24/7 availability and uptime for all databases.
• Improved SLA from 67% to 99.99987% uptime.
• Participate in planning strategies for future database needs for business needs in perspective of capacity planning, performance and available technology.
• Performed varies tasks involving all team members:
• Upgraded production and all test databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.4 to 12.0.1
• Apply Oracle CPU’s and all other necessary patches to database.
• Upgraded Grid Control 11.2.0.1 to 12c with weblogic
• Setup and configured Oracle Cluster Software (RAC) and converted ASM to Cluster. Once the cluster was setup and running converted single production instance to Cluster Database on a 3 node cluster.
• Helped developers tune SQL statements.
• Created Business Continuity plan - Installed Oracle Data Guard for Disaster Recovery.
• Created physical standay databases.
• Setup and maintained Goldengate for Oracle replication.
• Setup Oracle TDE for government clients.
• Setup and installed MySQL for in-house applications.
• Setup and migrated all reporting databases from oracle to EnterpriseDB (Postgres Cloud).
• Setup replication, backup and failover for all Postgres databases.
• Installed and maintained AWS (RDS Oracle, MySQL and Postgres databases for offshore projects. Installed Oracle and Mysql on EC2 systems.
• Monitor and manage Amazon cloud infrastructure.
• Migrated all Databases from Solaris Sparc to Linux VM
• Performed typical Database Administration duties, including creating and altering database objects, performing reorganizations at the object, tablespace, and datafile levels, determining appropriate settings of block space utilization and storage parameters preventing fragmentation on a day to day basis, identifying code within the application that could be tuned for optimal performance.
• Installed and setup Oracle cloud for offshore clients.

Confidential, Fort Worth, TX

Senior IT Manager - DBA

• Manage a team of 5 employees, consisting of DBA’s, Managers and Developers. Allocate/Forecast Budget. Provide upper Management with project status.
• Designed and Implemented production processes and procedures for Data Center.
• Worked with ITIL Director on polices for Database Standards.
• Recruit and train Oracle DBA’s to work in an ISO environment.
• Work with Auditors to make database SOX compliance.
• Work of Director of Infrastructure to insure all hardware and strategy needs are available.
• Communicate performance and represent Team in management meetings. Provide evaluations and highlight improvement with training and other solutions.
• Provide technical leadership to the Applications Support Team within the central

  systems department, as well as to Computer Services Managers in functional departments.

• Provided 24/7 support and 100 % database up time.
• Provided leadership role for the following tasks:
• Install, tune, manage Oracle Databases (9.0.1 - 10g); install new releases from software vendor, including coordinating the re-implementation of local changes to software package.
• Maintain and monitor Legato/AAM cluster software for PeopleSoft HR and Costpoint 4.0 - 5.1 Databases.
• Setup and Configured ASM volume manager for Oracle 10g.
• Wrote RMAN scripts to perform daily and monthly backups of Oracle databases using Legato Networker.
• Worked with Application Relocation team to move physical location of PeopleSoft HR database from one location to Fort Worth, TX
• Helped with the implementation and design for Disaster and Recovery site for all applications and databases.
• Cloned PeopleSoft and Costpoint databases for development and testing.
• Used SQR to modify existing reports where additional or different tables were needed.
• Helped with the implementation of Cognos ReportNet application. Created necessary users within Oracle for Cognos.
• Converted all Impromtu Reports to ReportNet 8.0.
• Created ReportNet 8 reports using the model and Tabular SQL.
• Installed and Managed Documentum v3.5
• Setup Oracle 10g RAC on a 3 node cluster.
• Maintained SQL Server 2000 and MySQL database, which was primarily used for TLS (Time and Labor).
• Created Stored Procedures and Triggers to meet Business Rules.
• Used Spotlight for Oracle and Quest Central to monitor performance of database.
• Performed typical Database Administration duties, including creating and altering database objects, performing reorganizations at the object, tablespace, and datafile levels, determining appropriate settings of block space utilization and storage parameters preventing fragmentation on a day to day basis, identifying code within the application that could be tuned for optimal performance.
• Used OEM to create and publish reports that give critical information regarding the database such as free space available, objects over high water mark, trend of growth etc.
• Setup Oracle 10g Grid Control to manage and maintain databases. Setup Flashback for oracle recovery. Setup Data Guard for Disaster Recovery - both Logical and Physical.
• Implement TDE for PII data.
• Work with Director of Security for quarterly user audits.

Confidential, Dallas, TX

Sr. Oracle DBA

• Provided weekly reports to upper management on all client engagements for all team members.
• Provided software design, development and customization services to major corporations.
• Numerous implementations to Oracle-based applications including Oracle Order Entry, Oracle Web Order Entry, Oracle Financials, Oracle E-Business Suite, a manufacturing system, a warehouse distribution center system, Oracle Production and Test systems.
• Worked with clients on Database Design (ERWin 3.5.2), Database Sizing (comprehensive excel spreadsheets), Database Performance and tuning, also backup and recovery procedures.
• Upgraded numerous Oracle 8i database to Oracle 9i and 10g
• Setup and maintained Oracle 10g RAC.
• Installed and implemented Weblogic 7.1 for clients. Created and deployed .war files for PLM system.
• Installed and configured eMatrix (V9 - V10) thick and thin client on Solaris, Linux, Windows/NT, HP, configured numerous AEF and eMatrix upgrades (from version 9 to version 10). Installed eMatrix Adaplet to connect to Legacy system. Setup and configured Map file.
• Assisted clients debug custom JSP code to enhance system performance.
• Created JPO triggers and methods for various clients.
• Provided clients with stress testing, regression testing, building scripts using Mercury LoadRunner. Also provided software recommendations to solve issues.
• Created and administrated AEF for clients. Setup users, roles and companies for clients. Debugged any issues with RMI and eMatrix performance.
• Created RFQ’s to meet client requirements.

Confidential, Arlington, TX

Sr. Infrastructure Consultant / Oracle DBA

• Mentored junior team members and new hires.
• Implemented two-tier and three-tier for the distributed eMatrix Application and Services using RMI, JDBC, JNDI APIs and EJB over WebSphere 3.5/4.0, WebLogic 5.1 - 8.1 and 9IAS application servers. Worked with QA on testing applications.
• Tuned Weblogic, WebSphere and Oracle 9IAS application servers. Also created and deployed .ear and .war files for desired web application.
• Configured Active Directories using LDAP, using both SunOne and Netscape LDAP.
• Installed and configured Netegrity Siteminder Web Agents for use with Sun’s iPlanet and Microsoft’s IIS web servers, with proxies to Weblogic application servers. Also configured Siteminder policy servers with appropriate policies and rules.
• Utilized object oriented perl, mod perl (Mason) with Apache web server (including LDAP authentication),
• Responsible for designing the infrastructure to support two-tier and three tier applications.
• Installed and configured Oracle 8i, 9i and SQL Server for clients on Windows NT/2000, AIX, Linux, Sun, and HP-UX.
• Upgraded Oracle 8i, 9i for clients and applied necessary patches. Also tuned Oracle Database for clients and advised and setup backup procedures. Helped clients with data migration and database design. Also helped clients design the client/server architecture.
• Implemented front-end Proxy servers using iPlanet, Apache and Tomcat. And back-end Web servers with WebSphere, WebLogic or iPlanet.
• Installed, Tuned and configured DB2 for clients for use with eMatrix.
• Performed numerous DBA (Oracle, DB2 and SQL Server) consulting services for clients. Including installing patches, doing upgrades and also worked with oracle forms and reports. Also created Reverse Engineering models using ERwin and doing data modeling for clients.
• Performed numerous stress-testing for client applications using Mercury LoadRunner. Built scripts for clients. And did numerous Installation and setup of LoadRunner.
• Configured and installed all VCP applications (eMatrix) for clients.