Application Database Administrator Job Description
Application Database Administrator Duties & Responsibilities
To write an effective application database administrator job description, begin by listing detailed duties, responsibilities and expectations. We have included application database administrator job description templates that you can modify and use.
Sample responsibilities for this position include:
Application Database Administrator Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Application Database Administrator
List any licenses or certifications required by the position: ITIL, DBA, SQL, MS
Education for Application Database Administrator
Typically a job would require a certain level of education.
Employers hiring for the application database administrator job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Information Technology, Design, Administration, Computer Engineering, Performance, Computer Information Systems, Management, Technical
Skills for Application Database Administrator
Desired skills for application database administrator include:
Desired experience for application database administrator includes:
Application Database Administrator Examples
Application Database Administrator Job Description
- Oracle ERP DB and application cloning, installation, configuration, patching, upgrades on AIX and Linux
- Automation of repeatable tasks
- Support 3rd party applications like Kofax Markview, Noetix, Cipher, Kewill
- Support the Value Chain Planning environment (VCP) which includes Demantra, OBIEE and ASCP
- Support and implement high availability and disaster recovery for databases using Oracle RAC, Oracle Data Guard, OEM 11g/12c, and Golden Gate
- Use Ignite and OEM for Diagnostics, Tuning, Monitoring and Configuration
- Perform backup and recovery procedures using RMAN with EMC Networker
- As a member of DBA team, participate in on-call rotation providing 24X7 support, which is generally on weekly basis
- Work on projects as needed in close coordination with Architects, PMs, Application architects, Development teams
- Bachelor’s degree in Computer Science, Information Technology or other technical discipline
- Advanced knowledge of Database Administration of large databases, Oracle E-business Suite R12 application and technology stack in a multi-tier environment
- Good knowledge of Oracle ASM and RAC, Oracle Active Data Guard, RMAN backup/recovery, Enterprise Manager Cloud Control 12c
- Strong shell, sql, pl/sql scripting skills, perl would be a plus
- Working knowledge of supporting databases on Exadata
- Experience working on AIX, Linux (RHEL, OEL)
- Expert at creating system design documents and diagrams
Application Database Administrator Job Description
- Recommend solutions by defining database physical structure, functional capabilities, security, data back-up, and recovery specifications
- Install revised or new systems by proposing specifications and processes
- Maintain database performance by calculating optimum values for database parameters
- Prepare users by conducting training, supplying them with information to answer questions/requests while resolving problems as they arise
- Contribute towards team effort by accomplishing related results as needed
- Proactively take steps to reduce day-to-day activities by automating administrative tasks using system tools, utilities, and other software
- Develop task oriented project plans and cost estimates
- Keep immediate supervisor informed of all problems and take necessary corrective action where appropriate or suggest alternative courses of action
- Perform any other duties as required or requested
- Install, configure, and manage database, application, and web servers
- Good knowledge of platform dependent programming language, control language, and system utilities
- Exposure to at least one flavor of UNIX / Linux and Windows systems
- Maintain a favorable working relationship with coworkers and customers to foster and promote a cooperative and harmonious working climate which will be conducive to maximum employee morale, productivity, and efficiency and facilitate activities with other teams
- Detail oriented, creative, resourceful and able to work independently part of a larger team
- Provide Level 2 DBA support to application teams on Production environments related to access, data refresh
- The IT Database and Application Administrator is part of WABCO’s global IS organization and is in charge of maintaining and supporting Databases and applications
Application Database Administrator Job Description
- Monitor all database and application systems (CPU, memory, storage, and general system availability.)
- Troubleshoot technical issues with database and application servers
- Ensuring the integrity of databases and application by running periodic maintenace routines and performing regular database backups
- Assist in creating interfaces that move data between disparate systems
- Automate repetitive administrative tasks through scripting
- Manage database and application users, security, etc…
- Work with developers to troubleshoot database and system related performance issues
- Participate in the planning and implementation of database and application upgrades
- Develop and maintain system documentation for all database and application instances, interfaces, and administrative processes
- Thorough understanding of Oracle database concepts
- Minimum 3 years experience in Administration and support with Windows and UNIX(Linux) systems
- Minimum 3 years experience in Database administration (Oracle, PL-SQL /T- SQL)
- Experience with Standby Database (Oracle Data Guard)
- Experience Restore and Recovery
- Skills in service management methods and tools
- A basic foundation of knowledge and skills in systems analysis and related programming support functions generally obtained by a bachelor's degree in computer science, or related area, or an equivalent amount of training and applied experience
Application Database Administrator Job Description
- Perform capacity planning including allocating system storage and planning future storage requirements
- Participate as Subject Matter Expert (SME) as required for design reviews and technology and tool selection
- Strong working knowledge of dataguard
- Provide guidelines for development and production running Peoplesoft FS/HR application and home grown applications
- Works with other Software Engineers to continuously improve production support levels
- Plan, perform and monitor database backups using Oracle RMAN Recovery Manager and work in Oracle cloud environment by managing the upgraded databases
- Perform full and point-in-time Oracle database recoveries
- Good understanding of SQL Server backups, restores, replication and log shipping
- Maintain and monitor database security
- Works closely with auditors in maintaining the audit standards for the databases
- Experience as Linux power user is required
- Bachelor's degree in Computer Science, Computer Technology, or related field or equivalent knowlege
- WABASH NATIONAL IS WILLING TO TRAIN A NEW GRAD RIGHT OUT OF SCHOOL
- Past record of leadership in organizations/groups that are not necessarily social but show leadership experience
- Track record with senior design projects to show thought processes and leadership
- The ability to streamline repetitive tasks using scripting and automation
Application Database Administrator Job Description
- Serves as escalation point for database issues
- Works closely with other system administrators, Software Engineers and production personnel to gain a thorough understanding of the architecture of the Production system being supported
- Helps to develop standards, policies and procedures best practices documentation
- Create and execute scripts for various database maintenance activities
- Participate in projects as the primary database resource
- Develop project estimates for database activities
- Perform database, application and system architecture design
- Keep current on database systems and features, 3rd party tools, and industry standards
- Works closely with Software Engineers to deliver creative solutions to complex technology challenges and business requirements
- Ensures infrastructure standards and best practices are followed
- Previous experience using/administering server operating systems (Windows/Linux)
- Previous experience with relational database administration and/or development, including Microsoft SQL Server, Oracle, MySQL, or a similar relational database system
- Previous experience with web server administration including IIS, Apache/Tomcat, NGINX, etc…
- Previous experience with virtualization and container platforms, specifically VMWare and Docker
- Passion for researching and implementing new technologies
- Bachelor's Degree in MIS or Computer Science related field