Junior DBA Job Description
Junior DBA
provides database administration support for the BLS Oracle database instances including development, test and production instances of Oracle.
Junior DBA Duties & Responsibilities
To write an effective junior DBA job description, begin by listing detailed duties, responsibilities and expectations. We have included junior DBA job description templates that you can modify and use.
Sample responsibilities for this position include:
Perform physical and logical database administration functions as required for Application Sustain Services
Create shell scripts and SQL scripts for database administration
Work with Customer and other Third Parties (Application, Architects, ITO personnel, tester etc) to support DBA functions
Provide appropriate resources and skill sets to support the DBA functions for the Applications as required
Review with Customer new Database Management System (DBMS) releases to understand the business and technical impacts
Set up and maintain test and production databases
Propose database changes to ease monitoring and administrative effort
Document and implement changes to databases via proper Change Management methodology
Monitor and analyze database activity to proactively identify and prevent potential Incidents and also recommend performance improvements
Participate in situation management of incidents related to database operations
Junior DBA Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Junior DBA
List any licenses or certifications required by the position: OCP, OCA, SQL
Education for Junior DBA
Typically a job would require a certain level of education.
Employers hiring for the junior DBA job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Technical, Computer Science, Technology, Engineering, Information Technology, Business, Science, Design, Associates, Education
Skills for Junior DBA
Desired skills for junior DBA include:
Oracle R12.2.6 E-Business suite
& Extended Events
2008 R2
Best practices in data visualization and business intelligence
Database administration
Experience in database environment life cycle management and support of production and development environments
JavaScript and REST APIs
Microsoft server operating systems
Operating Systems
Oracle Database Architecture
Desired experience for junior DBA includes:
Test and evaluate impact on Applications of new DBMS Software releases
Ensure integrity of all database components, eg
Report and remediate all security violations
Familiar with tuning utilities and reports
Familiar with Oracle CPU and PSU patching procedure
Capable of evaluating new RDMBS technology with the objective to improve the quality of database administrative tasks
Junior DBA Examples
1
Junior DBA Job Description
Job Description Example
Our company is growing rapidly and is looking for a junior DBA. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for junior DBA
- Be proactive in performance tuning and optimization to help improve database efficiency
- Implement and manage changes
- Excellent problem solver with strong attention to detail
- Implement, maintain and test backup and recovery processes
- Enforce security measures to protect company data
- Provide first level Support and maintain SAP ASE and MS SQL Server database environment
- Build database structures based on detailed design
- Performs database testing to ensure performance is met and compare with expected results
- Provides support during the system implementation and production
- Identifies gaps in scripts and procedures
Qualifications for junior DBA
- Bachelor of Science degree in Computer Science, Information Technology, or a related field of study from an accredited college or university within twelve (12) months of graduation date
- Master of Science degree in Computer Science, Information Technology or a related field of study from an accredited college or University within twelve (12) months of graduation date
- Knowledge of Oracle Database 12c
- Ability to efficiently write scripts with Oracle SQL queries
- Interested in a career as a database administrator
- Knowledge of Oracle DBMS concepts
2
Junior DBA Job Description
Job Description Example
Our growing company is looking to fill the role of junior DBA. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for junior DBA
- Work with Database developers and application developers to identify and resolve issues impacting production
- Integrate business vertical operational data needs into physical enterprise data model
- Function in 24x7 on-call environment
- Perform operational procedures and maintain records
- Interface with Tech Support for information gathering, trouble-shooting, and general technical support for security patches, installs, upgrades
- Perform installations and upgrades of PostgreSQL
- Manage database backups
- Define maintenance plans
- Configure replication
- Setup disaster recovery
Qualifications for junior DBA
- Should be willing to learn new technologies and be a self-starter
- Basic understanding of T-SQL concepts and syntax
- Outstanding team player with the ability to work independently
- Expert level knowledge on latest versions of SQL Server database (2012 and above),including troubleshooting and fixing performance issues, replication, backup/restore
- BA/BS in Computer Science or Information Systems or related field
- Basic knowledge of shell/PERL scripting
3
Junior DBA Job Description
Job Description Example
Our innovative and growing company is looking for a junior DBA. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for junior DBA
- IT Literacy and Microsoft Office skills
- Collaborate with system and network administrators
- Install system enhancements and assists in hardware, software and data utilization analysis to ensure maximum efficiency
- Participate in the design, implementation and testing of the disaster recover procedures
- Provide DBA support for custom application development efforts
- Analyze performance issues in the application, concurrent manager, and database tiers of E-Business Suite installations
- UNIX shell scripts plus
- Clone 12i environments
- Identify and correct 12i performance problems and monitors space usage
- Ensure the 12i system is appropriately secured and periodically audits the security of the 12i system
Qualifications for junior DBA
- Qualification in a relevant field
- Highly self-motivated eager to learn and embrace new technologies
- High quality and detail oriented
- Familiar with Crystal Reports
- Familiar with Microsoft SQL Server, Language and Database Environments
- Familiar with IT Administration (Lite) as a Help Desk / Technician Role
4
Junior DBA Job Description
Job Description Example
Our growing company is looking for a junior DBA. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for junior DBA
- Having experience on export and import in database environments
- Having knowledge on R12.2 plus
- Participate in on-call rotation providing 18*5 support
- Participating in customer and team calls every week for week end activities and
- Good Team Player with excellent Technical, Communication, Multi-Tasking, and Interpersonal Skills
- Release Code developed by developers
- Maintain Oracle database/Application User accounts
- Monitoring Ticketing tool
- Resolve database incidents
- Install and configure SQL Server instances
Qualifications for junior DBA
- Extensive SQL tuning experience
- Solid knowledge of Korn Shell scripting
- Scripting languages such as Shell/PERL
- Pachyderm
- Open Source tools (Telegraph, InfluxDB, Grafana)
- IT curriculum and Business classes, MIS preferred over Computer Science, with an emphasis on programming
5
Junior DBA Job Description
Job Description Example
Our company is growing rapidly and is hiring for a junior DBA. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for junior DBA
- Monitor servers for any performance issues
- Be familiar with company DR solutions and can implement them
- Perform other daily and weekly DBA tasks
- Complete Individual Status Reports (ISRs)
- Follow documented work schedule policy
- Ensure day-to-day running of SQL Server estate through, monitoring of disk space, backups, database mirroring, clustering, replication and troubleshooting failed jobs
- Knowledge of AWS and NoSQL Databases Mongo is a plus
- The candidate must have experience working in the database domain with at least four (4) years of experience managing all operations of RDBMS databases such as Oracle/SQL Server/DB2 with a minimum of two (2) years of EDB PostgreSQL DB
- Design and develop logical and physical database designs from application requirements
- Provides support to application development staff to ensure adherence to corporate database standards and best practices
Qualifications for junior DBA
- RPA programming (Blue Prism, Automation Anywhere, UIPath, AutoHotKey, etc)
- Web-Based programming/design
- Web Services -XML RESTful and SOAP
- Candidates must be flexible to work overnight and weekend coverage shifts
- Shares knowledge with peers
- Providing input into long-range database requirements