We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume Profile

5.00/5 (Submit Your Rating)

Conshohocken, PA

Summary

I am a personable and driven individual with excellent leadership and technical skills. I bring 20 years of experience in the IT field with outstanding performance at the technical and leadership levels and communicating effectively at all levels of the chain of command. I have a solid and proven track of success adding value to the organizations for which I have worked. Expertise on database administration and performance tuning with extensive knowledge and experience in IT operations, security, business continuity planning, application support and change management. Intimate knowledge of both Windows and Unix platforms including LINUX. My experience includes multiple implementations of ERP, CRM and WMS for regional and global enterprises participating on technical leadership roles. Additionally experience with migrations from one OS to another, migrations from one version to another including 9i to 10g and 10g to 11g. Implementation of Streams replication, physical and logical standby databases with DataGuard. Implementation of Advanced Security options such as Transparent Data Encryption and network encryption. Experience in single instance and RAC environments up to 4 nodes. While my expertise is more focused on Oracle technology I am well versed in managing MS-Sqlserver databases and currently support databases on 2008 and 2012 versions.

Extensive experience, solid skills and depth of knowledge are the qualifications I bring to the table to make a significant and tangible contribution to your organization's success.

Skills

ORACLE v6, v7, v8, v8i, v9i, v10G ,11gR2

Heterogeneous Dataguard 11gR2

Oracle Applications 11i

SOX-SAS70- ITIL Knowledgeable

Oracle Fail Safe / Clustering / RAC / Data Guard /ASM

Korn Shell Script/ VB Scripting / Windows Scripting

PL/SQL / SQL /TSQL

UNIX Solaris, AIX, HPUX

Oracle Streams

Oracle RMAN

Data Modeling

Data warehousing

Microsoft SQLSERVER

Teradata RDBMS

Linux RH 7.3/8/9

Netbackup

EMC / SRDF / BCV

Performance Tuning

Tomcat / Apache Web Server/IIS

Quest Software Tools

Windows 2003/2008 Server

Citrix Metaframe, Terminal Services

Oracle Enterprise Linux R5,R6

OS Migrations from Windows to Linux

Disaster Recovery /Business Continuity

Oracle Advanced Security

Transparent Data Encryption

Experience

Confidential

  • Support Client Registration System
  • Support in-house Item Banking System
  • Technical Lead for Item Banking System migration from in-house to ExamDeveloper.
  • Support database environments on both MS-SQL 2008 and Oracle 11gR2 Platforms linux . Design and architect database solutions. Support Oracle APEX Application Express environment, installation, upgrades, maintenance. Code development in PL/SQL. Monitor and ensure database performance, availability and recoverability.

Senior Database Administrator

  • Support several high visibility application databases. Support development efforts, troubleshoot performance issues. Create new databases using RAC/RAC1 and Dataguard technologies. Automate processes using scripting.
  • Participate in Data Center Migration efforts. Perform upgrades from 10g to 11g. Participate in sustain activities such as change management, patching, tuning. Formulate process improvements.
  • Senior Database Administrator
  • Team member in a high performance, leading edge Oracle technology environment.
  • Implemented technologies include Data Guard, Advanced Security, STREAMS, Database Vault and Partitioning all in 11gR2.
  • Perform Heterogeneous Dataguard configuration to support OS migration.
  • Support the data warehouse environment, performance optimization for a 13 TB data warehouse.
  • Responsible for the planning and execution of migration from Windows to Oracle Enterprise Linux R6.
  • Configure and support Oracle Streams to feed data warehouse.
  • Develop shell scripts, PL/SQL scripts and stored procedures.
  • Applications Analyst Principal 1 - PEGA Systems
  • Technical lead for the Compass/PEGA Systems solution.
  • Provide a holistic approach to application management and support for the entire technology stack.
  • Review system architecture and suggest improvements that result in performance gains and increased system stability and capacity.
  • Top Achievements include implementation of Load Balancing for PEGA Cluster with support for CTI components. Additionally implementation of web caching and compression resulting in reduced bandwidth consumption and increased performance.

Senior Oracle DBA

  • My participation here has added significant value to the global initiative, some of the achievements are :
  • Evaluate, train and mentor junior staff.
  • Assist in the development of the interface with the SAP ERP system based on Xi and SAP documents.
  • Develop and implement best practices for database systems administration. Developed solutions for data archival and systems support using PL/SQL, and APEX.
  • Participate in disaster recovery planning to support operations worldwide.
  • Performed migrations from 10G to 11gR1.
  • Manage the operational side of the Oracle 10G databases 4 NODE RAC in HP-UX, Dataguard, web, communication and application servers that compose the application environment.
  • Lead performance tuning efforts both at the database and application architecture level. Helped design, build, manage and tune a 4 node HP-UX RAC environment.
  • Provide focused attention to the specific needs of the High Jump application rollout develop procedures, documentation and standards in support of the environment.
  • Act as the technical liaison between the business, project managers and support personnel additionally interface with the application vendor to provide guidance for application enhancements and bug fixes.
  • Participate in a leadership and technical capacity in a multi-million dollar global implementation of the High Jump WMS application with a target of over 500 domestic locations and distribution centers, a key and strategic global initiative of Wolseley. Additionally provide leadership and direction to the implementation teams in Ripon, UK and Lyon, France.
  • Development and implementation of a standardized data archival and purging solution.
  • Development of Self-service tools for support groups
  • Standardization of deployment techniques and processes at a global level.
  • Development of technical processes that resulted in the elimination of physical inventory, saving hundreds of thousands of dollars and increasing productivity.
DBA/UNIX Systems Manager
  • Actively participated and mentor Jr DBA Staff on the following
  • Assist the IT Director on the preparation of budgets for the entire organization.
  • Review and determine requirements for new and additional hardware, evaluate maintenance contracts and support with vendors. Hire and manage consultants for project based initiatives.
  • Provide leadership on standards and best practices for database and UNIX systems administration and deployment. Ensure backup and recovery effectiveness and efficiency.
  • Hire, train and mentor junior DBA staff. Perform upgrades to database and applications, support users, resolve performance issues. Ensure 24 x 7 monitoring and response to alerts and other events.
  • Develop, implement and communicate controls in support of SOX and FDA IT compliance requirements.
  • Develop and implement best practices for database and UNIX systems administration .
  • Responsible for the service and support of the Oracle Applications 11i 11.5.9 ERP and Financial Systems, Factelligence manufacturing systems, TipQA Quality management systems and Applimation among other enterprise systems.
  • Perform on a leading capacity for the enterprise disaster recovery planning to support operations worldwide.
  • Supported database environments running Oracle and MS SQL-Server platforms.
  • In charge of managing and supporting the enterprise database and UNIX systems running on HP-UX for a worldwide user community.
  • Oracle EBiz Environment Cloning, Patching, Upgrading.
  • Oracle database tuning.
  • Oracle EBiz Environment system administration, defining printers, concurrent managers etc.

Major achievements:

  • Development of Business Continuity plan for mission critical applications
  • Implementation, including data center build out for off-site data replication.
  • Major overhaul of backup systems.
Information Technology Services Director
  • As IT Director my functions included among others, managing and supervising all Data Center operations. Develop and implement policies and procedures for database operations, systems security, backup and recovery, database replication, this included environments running both Oracle and MS-SQL Server platforms.
  • Ensure high level of availability for internal operations as well as for our hosted customers. Our data center provides application hosting services for the mortgage banking industry. Implement sound security practices including system hardening, intrusion detection and prevention and system auditing. Negotiate, implement and monitor Service Level Agreements with our hosted customers.
  • Ensure the highest level of quality customer service for our internal and hosted customers and serve as an escalation point for all problems and service concerns.
  • Implemented a Help Desk process and system to support internal and external customers.
  • Ensure IT compliance with Sarbanes-Oxley and SAS-70 requirements.
  • Implemented network security systems to ensure security and prevent intrusion, selected hardware including firewalls, routers and switches, network load balancing devices, implemented SSL encryption for email services and web applications and anti-spam appliances.
  • Provided cost improvements and added value to the operations by implementing Red Hat Linux as the platform for internal database operations.
  • Provide guidance and direction on database design and development issues. Managed all telecommunications functions.
  • Developed and implemented a comprehensive business continuity plan for our organization which included systems and data replication on remote sites to ensure timely and effective restoration of IT services in the event of a disaster.
  • Provided supervision, coaching and professional development to our IT staff. Developed the operating budget and manage and oversee all the hardware, software and facilities procurement process for IT needs.
Database Operations Manager
  • Lead the database operations group. Lead the implementation of Oracle Enterprise Server and deploy over 70 instances for the development, testing and production environments of PeopleSoft 8.
  • As the lead DBA for the PeopleSoft project I developed and implemented the security policies, database auditing strategy, designed and implemented a backup and recovery strategy in line with the needs of the business, created scripts for new objects, reviewed and optimized SQL code for developers. Ensured proper start and stop of the Process Scheduler, Application and Web Server processes. Cloned environments, and refresh existing copies for training and testing purposes. Managed the Change Control process for the development and production environments. Monitored and optimized performance of the environments both at the OS/Hardware level and at the SQL performance. Implemented data replication using Oracle Dataguard to replicate the PeopleSoft production systems from our headquarters in Memphis , TN to our recovery site in Nashville, TN.
  • Implement Oracle Enterprise Manager 9i and 9i Databases for high availability systems monitoring. Implement Oracle Names Server. Develop and implement all Database Administration and Backup policies for Oracle Databases in the bank. Implement Oracle Recovery Manager for Online Backups with Veritas NetBackup Data Center. Create Unix shell scripts to handle many tasks and automate them with Cron. Coordinated efforts of DBA team to support large number of projects. Act as corporate liaison between software vendors and UPB vendors included Oracle Corp., Quest Software and others. Develop Disaster Recovery plans implement Oracle Data Guard to provide high availability systems. Analyze developer SQL and PL/SQL code and suggest changes in order to increase performance in the database and applications. Create and edit PL/SQL stored procedures, triggers ,API calls, shell scripts and SQL statements for accomplishing data transfer and executing application logic. Develop procedures and strategies for data extraction, transformation and loading to and from heterogeneous data sources.
  • Developed and implemented database security policies to ensure SOX compliance and data privacy and integrity.
  • Propose and implement Oracle Data warehouse solutions using 9i, develop and implement physical model for operational data warehouse. Support MS-SqlServer, and IBM DB2 database servers and support ETL processes and interdependencies with the Teradata RDBMS data warehouse.
Senior Consultant
  • Support Oracle databases and Apps 11i environments. Provide support to internal development team. Install and configure multiple versions of Oracle database on Solaris, AIX, Compaq True64 and Windows NT. Installation experience including Oracle Financials 11i.
  • Provide full support for Oracle Applications Environments ver. 11i , perform maintenance of the database and applications, including patching, cloning and performance tuning. Setup various Oracle and third party monitoring tools such as Quest Iwatch, Spotlight, etc.. Also perform routine and special Database Administration tasks as required for multiple clients. Perform Remote DBA services which includes routine monitoring remotely via phone line/VPN to track tablespace usage, extent growth and to warn of impending show stoppers such as a tables not being able to grow in a tablespace, high loads on system, failure of listener, etc. Provide Unix system administration services such as OS install, patching, performance monitoring and tuning, security management and Backup and Recovery. Mentor Jr. DBA's in related technologies.
  • Install and deploy Oracle 9i Enterprise Edition database on Linux, Windows 2000, AIX 4.3.3 and Compaq True64, Implement Oracle Enterprise Manager 9i. Install and support Oracle 9i AS technology stack including Apache Web Server and JDK. Responsible for evaluating beta release Oracle products, administration and maintenance of all Oracle databases.
Database Administrator

Provided consulting services as an Oracle DBA. Supported 10 production databases 24/7 in the Windows NT, VAX Open VMS and Unix operating platforms. Supported multiple project and all related database development, assembly test, emergency recovery, performance testing, etc. Provided assessment to developers with data modeling, PL/SQL tuning, and data migration. Conducted performance tuning maintenance on production servers, as well as implementing database administration and monitoring software suites such as BMC's Patrol and Quest's Instance Monitor. Among the products supported wee ARIBA B2B, Siebel, Peoplesoft, and CrossWorlds.

Information Systems Consultant

Provided consulting services on the areas of Oracle DBA and Client/Server Development. Assigned to the GTE/Puerto Rico Telephone Co. Wireless Division Celulares Telefonica . Administered a 24/7 Database Operation with over 1.3 Terabytes of information for OLTP. Site configuration included Sun Enterprise 10K with 4 domains, Oracle8 Enterprise Server and EMC storage.

Developed and implemented backup strategies for both online and offline backups. Performed tuning and optimization of database configuration and application SQL, as well as performing system administration chores in Solaris, AIX and Windows NT. Administered database security, database availability troubleshooting, and lead the Database Administration Team. Designed user schemas and performed various data mining tasks for all levels of management. Installed and configured Oracle software on Solaris/AIX/Windows NT.

Oracle Development Manager

In charge of new product development, documentation and deployment. Designed and developed applications for various customers using Oracle technology. Provided Oracle DBA services for customer's sites, as well as providing system administration services to customers. Analyzed new technologies and market trends. Provided consulting services to customers for systems integration. Worked at the managerial level with the rest of the staff to provide effective and efficient solutions to the company's operational challenges.

Sales Manager

Directed a Sales Department with an annual sales volume of over 1,000,000. Developed and established structured price lists, sales policies, service and support contracts. Suggested new products that increased earnings, and coordinated efforts with R D and Technical Support departments to maximize customer satisfaction.

R D Manager

Designed and developed new applications in the area of Payroll Human Resources. Completed the conversion of existing product line using Oracle technology Developer 2000 and Oracle 7 Database. Designed and implemented interface with Oracle Financial GL module. Managed a staff of 6 programmers. Developed product documentation, and implemented training course for new recruits, which increased profitability speed. Assisted the Sales Manager in technical issues and documentation, as well as evaluating new technologies, programming languages and tools.

Programmer

Designed and developed applications using DataFlex 4GL. Provided both online and on-site support to customers. Also provided application and technical trainings to both customers and company employees.

We'd love your feedback!