Database Administration Job Description
Database administration
provides oversight to the production level ORACLE databases (Index maintenance, capacity planning, replication validate, Disaster Recovery planning).
Database Administration Duties & Responsibilities
To write an effective database administration job description, begin by listing detailed duties, responsibilities and expectations. We have included database administration job description templates that you can modify and use.
Sample responsibilities for this position include:
Work with application team to perform SQL tuning
Participate in database design/SQL code reviews for projects and enhancements
Maintain understanding of configuration of databases to lead the development and maintenance of procedures that ensure compliance with bank policies and standards
Use your thorough knowledge of database troubleshooting skills related to SQL Server
Consult database and advise best practice for use of SQL Server Databases
Day to day database maintenance tasks (Monitoring, Backups, space Management, resource utilization)
Create and maintain Oracle databases, database objects, including tablespaces, tables, indexes, views, synonyms, triggers, procedures, sequences
Based on the SLA, decide the backup/recovery strategy
Handle database security requests in development, test, production and disaster recover environments
Perform space analysis on tablespaces
Database Administration Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Database Administration
List any licenses or certifications required by the position: AWS, SQL, DBA, MS, MCSA, MCITP, MCTS, ITIL, OCP, II
Education for Database Administration
Typically a job would require a certain level of education.
Employers hiring for the database administration 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, Technical, Management, Information Technology, Engineering, Design, Information Systems, Technology, Computer Engineering
Skills for Database Administration
Desired skills for database administration include:
Integrity checks
Restores
Backups
Patching
Python
Configuration
Recovery models
SQL
Index management
AWS
Desired experience for database administration includes:
Programming skills for Perl and shell, including database access utilities (DBI/DBD)
Bachelor’s degree preferably in a technical discipline desired
Familiar with OEM from user perspective Diagnostick Pack/Tuning Pack
Freshman through graduate level course work at an accredited college/university with a major in Information Technology or other Technical degree
Bachelors degree or higher in IT, CS, IS, Engineering or a related field OR equivalent relevant experience
3 to 5+ years of IT infrastructure experience with a focus in security
Database Administration Examples
1
Database Administration Job Description
Job Description Example
Our company is growing rapidly and is hiring for a database administration. 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 database administration
- Coordinate the technical support and direction to application development, operations and other departments
- Expert knowledge of database security methodologies
- Manage install, patch, and upgrade of Oracle Server Databases, replication, and client environments
- Develop and establish department standards and procedures, and coordinate the technical support and direction to application development, operations and other departments
- Manages the internal and external staff on his/her team
- Ensures that all functions and activities are performed in accordance with accepted department standards and procedures
- Responsible for building and maintaining data systems including but not limited to Decision Support, Business Intelligence, Customer Relationship Management, Data Warehousing, Meta-data Repositories, Operational Data Stores, and Enterprise Storage Management
- Partner effectively with the Data Integration Lead and through them, with Enterprise Data & Client Insight counterparts, plan the direction of data technologies
- Assist with the evaluation of and make recommendations for new data-related technologies
- Work closely with various IT and Business Technology Partners and project teams to understand business unit needs for data and assist in design and implementation of databases and data software to meet business needs
Qualifications for database administration
- 3 to 5+ years of Database Administration (DBA) skills required
- DBMS query and troubleshooting skills
- Experience with DBMS & OS security tools, Audit and Compliance would be plus
- Minimum 5 years of solid DBA experience on Oracle
- The ability to asses, collaborate, provide servant leadership, listen and understand the team and the organization as a whole, and create a technology roadmap
- RAC experience
2
Database Administration Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of database administration. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for database administration
- Work with Information Services and other business counterparts to ensure solutions are scalable, efficient, secure, highly available, flexible and meet current and projected business needs
- Ensures data management infrastructure, tools, software and related solutions are compliant with bank policies and standards
- Experience with NoSQL databases MongoDB and Cassandra is plus
- Recruit, develop and retain staff, partnering with Sr
- Provide training and mentoring to other team members
- Use your knowledge of Windows Operating Systems
- Oversees the development and implementing of databases that address
- A traditional database design methodology that determine the data to be stored in the database, the relationships between the data elements, and superimposing a logical structure upon the data on the basis of these relationships for Relational Model Databases
- Provide database administration and management with Linux and Windows platforms/environments/tools (including operational and monitoring features)
- Monitor the daily performance of production and development environments
Qualifications for database administration
- 3+ years as an Microsoft SQLServer DBA
- 2+ years High Availability (Clustering, Log Shipping/Replication or equivalent)
- 2+ years working with SSIS/SSRS
- Exceptional experience administering various multi-Terabyte, 24x7 uptime SQLServer databases as a Systems/Infra DBA required
- Knowledge of database security management and data integrity concepts, knowledge of ETL and query tools, and experience in code migration, database change management and data management through the various stages of the development life cycle
- Strong experience working with SQLServer 2008r2 and 2014
3
Database Administration Job Description
Job Description Example
Our innovative and growing company is looking for a database administration. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for database administration
- Ensure all regular patching and security updates in a timely manner
- Manage installation and configuration of Oracle 10g and 11g instances in both dedicated, consolidated, RAC, and Exadata environments
- Provide a support on any kind of Infrastructure changes affecting the database environments
- Perform operational aspects of high availability (clustering and related, including replication) solutions, and database security related concepts and designs (SOX compliance), are essential
- Technical lead in critical database projects during requirements, design, development, QA, production implementation and monitoring phases
- Current with new database technologies, new features, monitoring and tuning tools industry standards and best practices
- Must have extensive knowledge of Linux and Solaris operating systems
- Working with other infrastructure support teams (O/S admins, web server admins, network admins, database engineering, information architects)
- Assesses and develops long-term strategic goals for production databases in conjunction with data owners and department managers
- Works with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures
Qualifications for database administration
- Extensive experience with Backup and Recovery
- 5+ years High Availability (RAC, Clustering, Log Shipping/Replication or equivalent)
- 2+ years of working with off-shore teams
- Strong experience working with Oracle version 12c in a UNIX environment required
- Knowledge in Dimensional modeling like Star schema and Snowflake schema
- Understanding Dimensional modeling like Star schema and Snowflake schema
4
Database Administration Job Description
Job Description Example
Our company is looking to fill the role of database administration. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for database administration
- Develops, implements, and maintains policies, procedures, and associated training plans for database resource administration and appropriate use
- Installs and configures relevant network components to ensure database access database consistency and integrity
- Designs and implements redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets
- Creates, or supports creation of, required reports in response to business user needs
- Conducts research and makes recommendations on database products, services, protocols, and standards in support of procurement and development efforts
- Performs database transaction and security audits
- Establishes and maintains regular written and in-person communications with the organization's executives, decision-makers, stakeholders, department heads, and end-users regarding pertinent database activities
- Manage a team of (7) Oracle DBAs split between both domestic and offshore
- Coordinate weekly project and operational team meetings -- driving agile project tracking, reporting, planning, and resourcing
- Maintain and meet all audit and regulatory compliance standards and controls -- including but not limited to user access, data restrictions, and process controls
Qualifications for database administration
- Excellent technical knowledge of Data Warehousing, Meta-data Repositories, Operational Data Stores, and Enterprise Storage Management
- Experience in hardware / asset management in Financial Services / Banking
- Develop and implement the standards and desk procedures to be used by client DBAs in all regions (EU, AP, NA)
- 2+ years working with DB2 utilities (reorg, image copy)
- IBM utilities (IEBGENER, IEBCOPY)
- High Availability Options With SQL Server
5
Database Administration Job Description
Job Description Example
Our growing company is looking for a database administration. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for database administration
- Install/configure/manage DB2/Oracle Databases
- Maintain and monitor backup of databases
- Perform Database Query tuning as required
- Manage Database Objects
- Collect Database performance metrics for weekly/monthly and quarterly review
- Perform Systems Administration of DB OS (Unix)
- Perform Capacity planning for building and maintaining databases
- Collect OS performance metrics for weekly/monthly and quarterly review
- Support recovery of systems during outages (with on call duties)
- Share responsibility for the administration and maintenance of the computer system of the Center for Immune Cell Therapies (CICT)
Qualifications for database administration
- Deep knowledge of MySQL, and an understanding of SQL and Oracle
- Strong, proven SQLServer Database Performance Diagnostic skills (at both the SQL and system levels) required
- Strong programming experience in SQL and Shell Scripting required
- Thorough Understanding of Backup and Recovery Processes with SQL Server
- Thorough Understanding to Identify and Deploy Performance Tuning Improvements with SQL Server
- Thorough Understanding of Monitoring Techniques