4bc7cd07-3eb3-49e3-a94b-256c74f6ab55

Andrew Smith


287 Custer Street, Hopewell, PA 00000

andrew_smith@example.com

(000) 000-0000

Professional Summary

Hands-on, successful Software Engineer with decades of verifiable success leading teams in delivering appropriate technology solutions for desktop and mobile products.  Comprehensive knowledge of platform development, enterprise architecture, agile methodologies, cloud services, and web-based applications.  Innovative change agent with a unique mix of high-level technology direction and deep technical expertise.

Employment history

Oracle Database Administrator, Halvorson, Murphy and Berge. North Ara, Nebraska
Aug. 2016 – Present
  • Demonstrate database technical functionality, such as performance, security and reliability.
  • Plan and install upgrades of database management system software to enhance database performance.
  • Provide technical support to junior staff or clients.
  • Set up database clusters, backup, or recovery processes.
  • Oracle 10g/11g/12C Installation on Rhel 7, Windows 2008/XP and client on terminals.
  • Managing 12c OEM.
  • Managing Tablespaces and data files, redo log groups and members.
  • Creating users and granting them roles and privileges.
  • Deploying SCR’s.
  •  Refresh of production data into UAT by restoring and recovering databases for user tests and requirements.
  • Look for harmful Growth Rates. Implementing daily, weekly, nightly, Monthly policies and procedures in crontab.
  • Providing support to development team, like Database changes, Trace and kill sessions.
  • Creating and Rebuilding indexes, Creating and Refreshing of Materialized views, Analyzing Schemas.
  • Managing Daily backups using RMAN.
  • Checking errors in Alert Log/trace files.
  • Managing Golden Gate.
  • Creating and scheduling shell scripts in cron as per requirement.

Oracle Database Consultant, Roob, Heidenreich and Larson. Lake Virgil, New Jersey
Apr. 2011 – May. 2011
  • Oracle 10g/11g Installation & database creation on Rhel 5.4, Windows 2008/XP and client on terminals.
  •  Managing 11g/10g Datagaurd (Physical Standby Databases).
  • Applying Opatches.
  • Database 9i to 10g upgrade + platform migration using export / import.
  • Refresh of production data into UAT by restoring and recovering databases for user tests and requirements.
  • Reorg, index rebuilding.
  • Schema refresh, cloning.
  •  Standby database creation.
  • Managing Tablespaces and data files, redo log groups and members
  • Creating users and granting them roles and privileges.
  • Look for harmful Growth Rates. Implementing daily, weekly, nightly, Monthly policies and procedures in crontab.
  • Providing support to development team, like Database changes, Trace and kill sessions.
  • Creating and Rebuilding indexes, Creating and Refreshing of Materialized views, Analyzing Schemas.
  • Managing Daily backups using RMAN. 
  • Checking errors in Alert Log and monitor trace files.

Education

Western Armstrong, Luettgenmouth, Oregon
B Com, Commerce

Skills

Mongo DBA

Postgres DBA

Oracle Database Administrator

24d0c02f-9b39-40ae-8366-c6e9a1e7be60

Andrew Smith

287 Custer Street, Hopewell, PA 00000
andrew_smith@example.com
(000) 000-0000

Professional Summary

Hands-on, successful Oracle Database Administrator with decades of verifiable success in a wide variety of DBA disciplines.  Comprehensive knowledge of platform development, enterprise architecture, agile methodologies, cloud services, and web-based applications.  Innovative change agent with a unique mix of high-level technology direction and deep technical expertise.

Employment history

Oracle Database Administrator, Barton LLC. New Bonniestad, Indiana
Mar. 2000 – Present
Manage Oracle database administration environments for the Department of Defense.  Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.

  • Demonstrate database technical functionality, such as performance, security and reliability.
  • Design database applications, such as interfaces, data transfer mechanisms, data partitions, and function-based indexes to enable efficient access of the generic database structure.
  • Develop data models for applications, metadata tables, views or related database structures.
  • Test changes to database applications or systems.
  • Oracle WebLogic tuning and administration
  • Developed and executed a plan to transition an Oracle Financials database system to production (HP-UX) from development. 
  • Configured Oracle Application Web Server (HP-UX and Windows NT) to facilitate the web user interface. 
  • Configured Oracle Enterprise Manager to assist other Database Administrators with managing the environment. 

Oracle Database Administrator, Toy LLC. Daltonmouth, Kentucky
Feb. 1997 – Nov. 1998
Responsible for all oracle database environments, including production, development and test. Provided a wide range of Database Administration support for database environments including backup/recovery, standby (for offsite disaster recover facility), tuning, design, database conversion from RDBMS 7.1 to RDBMS 8.05 (Novell, Windows NT, LINUX), growth planning, sizing and training for junior database administrators. 

Oracle Database Administrator, Fay, Bradtke and Treutel. North Kent, Indiana
Dec. 1993 – Jul. 1995
Responsible for the Marketing Division Oracle database environments, including production, development and test. The production system was designed as an Operational Data Store/Data Mart to assist managers in determining the efficiency of advertisement campaigns. Provided a wide range of Database Administration support for all environments including backup/recovery, tuning, design, database upgrades from RDBMS 7.1 to RDBMS 7.3 (HP-UX), growth planning and sizing. 

Programmer, Schultz Group. Julianafort, Iowa
Sep. 1993 – Oct. 1993
Analysis, design and programming of 
miscellaneous systems using Paradox for Public Relations and Certification departments and the Bank Marketing Association. Taught entry-level classes in Paradox. 

Programmer, Murphy Inc. Griceldafurt, Texas
Feb. 1991 – Oct. 1993
Maintained many pieces of the toll billing system utilizing Cobol on Honeywell and IBM mainframes. Developed and taught PC software courses to coworkers facing layoffs. 

Instructor, Gutkowski-Runolfsdottir. Bergstromview, New Jersey
Jan. 1993 – Feb. 1993
Instructed several Introduction to UNIX/MAILX/Crystal and Lyrix classes to employees. 

Skills

Oracle Database Administration

Performance Tuning & Capacity Monitoring

Data Security, Backup & Recovery

Standby/Failover Administration

Database-Backed Web Solutions

SQL Tuning in an Oracle Environment

Education

Eastern Mertz, Edgardoberg, Michigan
Security +

West Hayes Academy, Denesestad, Missouri
Certified Oracle Database Administrator (OCP)

Eastern Pacocha University, New Robbiestad, Connecticut
Bachelor of Arts, Computer Information Systems, Nov. 1986

oracle database administrator

  • Patching Database with OPatch and Capacity planning and Participating Quarterly Downtime activities.
  • Installations/Creations/ Upgrading database 10-11g version and Documentations
  • Working on Email alerts/incidents and other DBA activities on demand
  •  Oracle flashback  
  •  Oracle resource management  
  •  Oracle Data Guard Installation for Oracle Database 
  •  Oracle PL/SQL Developer

oracle database administrator

  • Design database applications, such as interfaces, data transfer mechanisms, data partitions, and function-based indexes to enable efficient access of the generic database structure.
  • Oracle WebLogic tuning and administration
  • Developed and executed a plan to transition an Oracle Financials database system to production (HP-UX) from development. 
  • Configured Oracle Application Web Server (HP-UX and Windows NT) to facilitate the web user interface. 
  • Configured Oracle Enterprise Manager to assist other Database Administrators with managing the environment. 

oracle database administrator

  • Involved in gathering user requirements, application design, and analysis of hardware requirements to meet business needs
  • Scheduling the databases backup using Cron tab
  • Performed day-to-day database administration tasks like table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup
  • Configured of system to achieve high availability, load balancing and automatic fail over functionality.

junior oracle database administrator

  • Managing Daily backups using RMAN.
  • Checking errors in Alert Log/trace files.
  • Managing Golden Gate.
  • Creating and scheduling shell scripts in cron as per requirement.

senior oracle database administrator

  • Need to coordinate with the Application team to perform any changes in the Databases.
  • Perform scheduled COB(Standby) testing for production databases in conjunction with application team.
  •  Day to day monitoring like availability of system, listener, database, alert log file, trace file.
  •  Performance & Tuning of the Database
  • Attend daily/weekly conference call to discuss the build status with application team and Citi management
  • Open a Change review call with all the Oracle Specialists and Managers and discuss about the changes in the databases and explain the justification of the changes.

sr. oracle database administrator

  • Defined Data Models, Data Governance, Data Quality and Metadata strategy, Data Security Standards, Data Flows, Storage and Archiving mechanism 
  • Defined the Data Clustering and Replication policies and data flow pattern across the enterprise Application consumption
  • Developed HDL framework and Logical Solution design document for implementing project
  • Involved in all aspects of the application development lifecycle, which includes business
  • Requirements, functional specifications, architectural specifications, development, test plans, and documentation

oracle database administrator

  •  Administering Database Creations and Database upgrades from 11G to 12C, other activities including Backup & Recovery using RMAN. 
  • Performing Database (DB) tuning & performance monitoring as well as capacity planning for growth and changes; undertaking Patch Management and Version Control. 
  •  Recommending production database best practices, analyzing the existing database structures and developing new code to provide solutions for new requirements. 
  • Supporting Application Development Teams throughout the project lifecycle. 
  • Assisting in code migration, database change management, and data management across various stages of the Software Development Life Cycle (SDLC). 
  • Responding to and resolving database access and performance issues. 
  • Ensuring the integrity and security of enterprise data on host computers, multiple databases, and during data transfer while adhering to privacy, security, and regulatory compliance. 

oracle database administrator

  •  Install, clone and create oracle database  
  •  Configure database initializations  
  •  Database storage management  
  •  Oracle user management  
  •  Oracle performance monitoring  
  •  Oracle data movement using export and import 
  •  Oracle backup and recovery using rman 

oracle database administrator

  • Develop test scripts which can be used for automated as well as manual testing.
  • Have 2.5 years experience on “Informix” production servers and 1 year on “SQL” servers. Provided assistance for database monitoring and maintenance with regular statistics and backups. 
  • Providing support to development team, like Database changes, Trace and kill sessions.
  • Creating and Rebuilding indexes, Creating and Refreshing of Materialized views, Analyzing Schemas.

junior oracle database administrator

  • Working on DBA activities like Refreshes from DR database, Table Reorg, Data Refreshes.
  • Putting Standby DB to Flashback mode when required by Application teams.
  • Restoring RMAN backups, Working on RMAN Backup Failures
  • Working on all DB L1 issues, adding ASM disks to disk groups
  • Daily health checkups and Monitoring DR log sync
  • Implemented Dataguard with maximum availability, protection ,performance modes.
  • configurations and worked with dataguard switch over

oracle database administrator

  • Oracle 10g/11g/12C Installation on Rhel 7, Windows 2008/XP and client on terminals.
  • Managing 12c OEM.
  • Managing Tablespaces and data files, redo log groups and members.
  • Creating users and granting them roles and privileges.
  • Deploying SCR’s.
  •  Refresh of production data into UAT by restoring and recovering databases for user tests and requirements.
  • Look for harmful Growth Rates. Implementing daily, weekly, nightly, Monthly policies and procedures in crontab.

junior oracle database administrator

  • Supporting 2000+ oracle databases as Oracle database administrator in GE Corporate Servers which includes development, stage, and production oracle databases.
  • Implemented Backup and recovery using RMAN incremental and cumulative backups. Scheduling the databases backup using Crontab. Monitored Day-to-Day backups, logs and recovering them as per the requirements. 
  • Supported Patch assistance for Unix team for Cluster Patching. 
  • Interacting with the Oracle support on Service Requests and implementing the solutions for successful completion of tasks.

oracle database administrator

  • Communicate with customers and business leaders in requirements gathering and providing technical and functional solution definition for assigned Oracle projects. Ensured high availability and performance  in production and test environments. 
  • Implementing 3-node RAC concepts in different UNIX platforms and perform tuning operations on both Oracle 11g,12c technologies and monitored the production Oracle alert logs for database errors.
  • Detecting and diagnosing production system performance tuning of the database – SQL tuning, used tuning utilities like AWR,ASH report, ADDM, measuring system and database activity, querying Oracle dynamic performance views. 
  • Database replication using snapshots,import/export and traditional replication methods. 
  • Managed appropriate use of free space within Tablespaces , reclaimed space and reorganized tables and indexes within databases when needed. 
  • Resolved the issues in conflicts between the target and source database in Goldengate. Involved  in resolving bi-directional replication issues. 
  • Used Datapump tool  for exporting and importing the data between databases. 

oracle database administrator

  • As an Oracle database administrator providing operations-oriented support to help in managing underlying systems that drives core data for Woolworths Limited(Client), Australia
  • Managing and providing HA (High Availability) solutions like RAC, Data Guard etc.
  • Core Database upgrade and patching. 
  • Oracle RAC upgrade and patching. 
  • Optimizing Database/SQL performance.
  • Managing database that runs on EXADATA box and helping in levering Exadata key features. 
  • Helping in configuring disaster recovery.