OBJECTIVE:

Seeking a challenging career as a Senior Database Administrator

SUMMARY:

• 22+ years of experience as Advisory Engineer, Senior System Analyst, and Senior Oracle DBA
• Solid experience with all phases of software development life cycle involving Systems Analysis, Design, Development, and Implementation
• Experience with installing, configuring, and monitoring system applications
• Oracle Certified in Oracle 8i & 9i technologies. OCA in Oracle 11g database
• Experience with Oracle 9i/10g/11g/12c and Oracle 10g/11g RAC
• Experience in SAP, Business Object, Hana, and CLM Oracle databases
• Extensive knowledge in Backup and Recovery, Performance Tuning, Migration, Oracle Enterprise Manager (OEM), PL/SQL, and Oracle Recovery Manager (RMAN)
• Experience with performance tuning with the use of OEM, AWR, ADDM, explain plan, TKProf, and Statspack for diagnosing performance issues and optimizing applications
• Manage and support 24/7 Production Databases as well as staging, development, & QA databases
• Experience in High Availability global environment including Oracle standby databases and Oracle Data Guard
• Ensure highest level of regulatory compliances are implemented by following universally accepted guideline standards
• Experience with installing, configuring, and monitoring MySQL and phpMyAdmin 3.3.9.on MS Windows and Unix
• Experience with creating customized scripts utilizing UNIX/Linux shell scripts and Oracle PL/SQL, using job scheduler like crontab
• Team player with excellent interpersonal & troubleshooting skills with proven leadership qualities

TECHNICAL SKILLS:

Skills: Oracle, MS SQL Server, Pro*C/C++, C/C++, and Java, XML, JSP.

Operating Systems: MS Windows (2000/2003/2008/2012 R2), MS DOS, Open VMS, HP/SCO/ULTRIX/Digital UNIX (OSF1), Sun Solaris x86, Sun Solaris x86 - 64, IBM AIX, and Sun Solaris SPARC.

Programming Languages and Scripting Tools: Java, C/C++, Pro*C/C++, SQL*PLUS, SQL Loader, MS Visual Basic, FORTRAN-77, Pascal, Assembly VAX/11, X Windows, Tcl/Tk, Motif, Lex & Yacc.

Databases (RDBMS): Oracle, MySQL, Ingres, MS SQL Server, SQL Anywhere, and MS Access.

Tools: SAP Solution Manager 7.1, SAP DBA Cockpit, Networker for Oracle backups

Network Protocols: TCP/IP, NetBEUI, Novell (IPX/SPX), Procomm Plus, and other VPN/PPP/SLIP utilities

System Hardware Upgrades: Installation of peripherals such as motherboards, network interface cards, hard drives for Apple/Macintosh and PCs.

Miscellaneous: MS Office, WordPerfect, Visio, Lotus 1-2-3, Aldus PageMaker, Canvas, SharePoint, SVN, and HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior Database Administrator

Responsibilities:

• Installing, managing and supporting Oracle 81, 9i, 10g, and 12c production and non-production databases running on Red Hat Linux, Sun Solaris, IBM AIX and Windows operating system
• Managing, maintaining, and performing backup and recovery processes and procedures for Oracle databases using RMAN, Oracle Enterprise Manager Grid Control, and dataguard techniques
• Supporting, restoring and refreshing SAP and Tobin production and non-production databases running on IBM AIX platforms.
• Apply production and non-production Oracle databases upgrade and patches
• Assist, review, and maximize performance and implement fine tuning procedures for Oracle databases running in SAP, Tobin, Petro technical and Enterprise environment
• Provide 24 x 7 customer support along with other database administrators to maintain production environment

Confidential, Houston, TX

Senior Database Administrator

Responsibilities:

• Worked in Confidential environment to provide support and built Oracle 10g/11g RAC, 10g/11g/12c database systems for varieties Applications for build, routine maintenances, production support, application releases
• Performed backup and recovery procedures using RMAN, Flashback database. Used ASM, active standby database extensively
• Maintained, supported, and configured DR sites using Oracle Data Guard, log shipping, clustering, and other methods of disaster recovery
• Performed logical and physical database design including maintenance of database dictionaries and monitoring of standards and procedures
• Solid skills in database performance, fine tuning, and optimizing poorly performing queries and stored procedures
• Created databases, users, and other database objects. Applied production patches and upgrade Oracle databases. Configured OEM for the database alert, monitor
• Day to day 24 x 7 production operation support that included incident break/fix, change service request, vulnerability management, and customer support and communications

Confidential, Houston, TX

Senior Database Administrator

Responsibilities:

• Responsible for managing the EPM operations Oracle RDBMS on both Unix and MS Windows servers, and managing MS SQL Server environments
• Created new database environments for client services, backup and restoring databases (Oracle/SQL Servers) for client services and development teams
• Worked with client services and development teams to identify performance issues and made recommendations to correct it
• Troubleshoot database issues related to applications or database upgrades
• Installed new Oracle software, researched new Oracle and SQL software features and products
• Restored and Refreshed staging & development databases for client services and development teams and performed Complete or Point-in-Time recovery as needed
• Developed and configured Oracle PL/SQL scripts, wrote and automate C shell and bash scripts
• Worked with client support and professional services as necessary on client issues

Confidential, Houston, TX

Advisory Engineer / Database Administrator

Responsibilities:

• Lead a team of performance analysts and technicians, who were responsible for setting up and delivering data configuration and management systems using Oracle 7.x to Oracle 11g as a back-end database on Unix and MS Windows servers based infrastructure using large shared storage systems
• Assigned, managed, and coordinated business user projects and implemented with minimum affect to the business community in timely fashion.
• Analyzed system processes and provided documents to improve performance for system applications to users and customers
• Installed & Configured Oracle 8i, 9i, 10g & 11g on Sun Solaris 8/9/10, Migrated/Upgraded databases from 7.x to 8i, 9i to 10g, and 10g to 11g in compliance with the 3rd party applications and applied Oracle patches as available and necessary.
• Performed system wide Performance Tuning including memory, SQL & PL/SQL, monitoring locks & processes using OEM and other conventional methods as necessary based on business requests.
• Created and managed Materialized Views & refresh groups to optimize business processes.
• Configured OEM to manage and monitor databases by setting appropriate metrics and thresholds, Schedule & Monitor Jobs for backups, to gather statistics and other administrative tasks. Setup E-mails or Phone Alerts for critical issues, warnings and status updates.
• Utilized CRON to schedule customized jobs for few legacy systems & applications.
• Performed capacity planning & Load balance for databases among different servers to optimize the use of available resource and improve the overall system wide performance.
• Administered maintained and implemented policies and procedures for ensuring the accessibility, integrity and security of all databases in compliance with the SOX policies and procedures by setting appropriate Users, Roles & Profiles and evaluated usage of Database links.
• Involved in planning & designing High Availability architecture environment, including Data Guard & RAC technologies and tested & evaluated it in conjunction with the other infrastructure teams.
• Designed and developed Database Wizard by using Java, JDBC (Oracle Thin Client), and JDK for OLTP data configuration and management systems that supports tracking and managing data, documents, products, and processes.
• Installed, configured, and maintained Oracle 10g RAC on virtual machines to support in-house databases
• Backup using conventional scripts, RMAN, Export/Import & Data Pump.
• Responsible for performance tuning with and without the use of OEM, explain plan, TKProf, and Statspack for diagnosing performance issues and optimize applications.
• Successfully converted in-hose Oracle based Configuration and Management application to run on MS SQL.

Confidential, Houston, TX

System Analyst

Responsibilities:

• Installed, configured, and provided support for system applications to the end users in various departments
• Installed, administered, configured, and managed Oracle 7x, 8x, 9i, and 10g databases on Windows, HP 9x and HP 10x, Sun Solaris 5.8 and 5.9, and Windows platforms.
• Migrated and upgraded databases from Oracle 7.x to Oracle 8i, and Oracle 9i to Oracle 10g and apply Oracle available patches.
• Optimized and fine tuned Oracle Energy application using TKProf and Statspack
• Installed and configured MS SQL Server 7.0 on Windows NT 4.0 and Windows 2000 platforms.
• Developed and designed shell scripts, batch files, and small programs that were needed for databases hot/cold backup, recovery, and refreshes.
• Administered and deployed Oracle 7.x/8.x distributed databases on HP 9.x and 10.x and Windows NT 4.0 platforms.
• Designed and implemented Oracle's physical and logical backup and recovery routines by using appropriate archiving mode.
• Exported the database and imported the data back into the same or a different database.
• Administered and performed Year 2000 compliance projects for Oracle 7.x databases on HP 9.x and 10.x platforms by using PL/SQL packages, procedures, and functions with cursors and exception handling routines.
• Installed, configured, and administered SQL Anywhere databases on Windows NT 4.0 platform.
• Also managed and maintained:
• Database structure and users.
• Rollback segments.
• Accessing and updating data.
• Storage allocation and transaction concurrency.

Confidential, Houston, TX

Software Engineer (Oracle DBA/Developer)

Responsibilities:

• Worked as a DBA for the Oracle 7.2 server and Ingres 3.0 Server on SCO UNIX development platform.
• Developed a Delivery Time Tracking System suing Pro*C/C++, and Vermont View on SCO UNIX. This real time system monitored time taken by specific sun tasks while maintaining data integrity, and generated various management reports. DTT used Oracle 7.2 clients installed on store’s SCO UNIX system, maintained information through a wide area network from Oracle 7.3 database that was installed on Alpha VAX/VMS
• Developed a web project that integrated MS Internet Information Server 2 running on MS Windows NT Server 4 with the Oracle Enterprise Server 7.3 running on ALPHA/VMS using ODBC
• Developed solutions for store performance monitoring systems that provided critical information for the management. Those solutions included combinations of client/server applications that were developed under Pro*C/C++
• Developed, maintained, and installed system interfaces. Those system interfaces communicated between many in-house systems that were written in Pro*C/C++ on DOS, SCO UNIX, VAX/VMS platforms. Those in-house systems included a variety of major auto-supply Warehouse Management Systems (WMS) like CCI, Catalyst, and Carousal operated on TCP/IP, IPX/SPX, and RS232 communication protocols. This position needed proper exposure to cross-platform integration and in depth knowledge of software development life cycle (SDLC)
• Developed and designed shell scripts, batch files, and small programs that were needed for the regular system maintenance