Database Admin Job Description
Database admin
provides operational database support for a multi-site enterprise environment which includes Very Large databases (VLDB), AlwaysOn and Replication.
Database Admin Duties & Responsibilities
To write an effective database admin job description, begin by listing detailed duties, responsibilities and expectations. We have included database admin job description templates that you can modify and use.
Sample responsibilities for this position include:
Daily management of major applications and subsystems
Complete common core tasks include creation of pre-production code backups, new database updates, configuration file updates, database configuration changes, database engine installation and setup, registry changes, virtual and physical IP address assignments, optimization of environments, installation of database tools, cluster building, database tuning and optimization
Use system incident and change management systems to document activities
Ability to lead a team and individual effectively
Tier II/III – IV O&S responsibility of the SQL Server 2014 database
Collaborate with the DTF, Engineer and Transition teams on the development of patches that will be applied to the Production system
Manage and monitor performance of SQL Server and database infrastructure (including storage) using various performance tools
Mentor junior database administrators and drive SQL Server installations, database migrations, upgrades and updates, and hardware implementations
Perform database administration functions including
Perform installation, maintenance and upgrade to the new version of MSSQL databases
Database Admin Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Database Admin
List any licenses or certifications required by the position: II, IAT, SQL, SSCP, GSEC, GICSP, CSA, CCNA, DBA, OCP
Education for Database Admin
Typically a job would require a certain level of education.
Employers hiring for the database admin job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and University Degree in Computer Science, Education, Engineering, Technical, Information Technology, Information Systems, Administration, Mathematics, Management, Business
Skills for Database Admin
Desired skills for database admin include:
Industry-standard
Enterprise-class best practices for a large database environment
Agile and Scrum methodologies
MS DB backup and recovery scenarios
AWS/Cloud environment
Physical database design
Data replication
High availability
Indexes
DBMS and admin tools
Desired experience for database admin includes:
Attention to detail and a pro-active approach
An interest in the Irish commercial property market
Relevant project management/database administration experience
Configuration and maintenance of Microsoft SQL Servers
Solves problems using existing solutions
Impacts a range of activities within own team and other related teams
Database Admin Examples
1
Database Admin Job Description
Job Description Example
Our innovative and growing company is looking for a database admin. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for database admin
- Tier II – III O&S responsibility of the SQL Server 2014 database
- Ensure backup and recovery strategies meet the business’ Recovery Requirements and Time Objectives
- Configure and maintain SQL Server monitoring utilities
- Work closely with Systems Programmers and Systems Administrators to ensure that the database system is operating in accordance with required system usage
- Responsible for applying problem-solving techniques to identify issues in the database and software
- Other responsibilities include establishing new user accounts, assigning privileges, and maintaining system security, troubleshooting system and software problems
- Participate in 24x7 on-call support and planned downtime maintenance activities
- Work closely with Truven DBA and data warehouse team (e.g., project lead, data modelers, technical team, ETL developers) to deliver project milestones
- Ensure compliance with all technical specifications
- Ensure that department documentation is up-to-date and accurate
Qualifications for database admin
- Oracle OEM/Grid Control experience
- Ability to work directly with business stakeholders technical resources
- Excellent project management and motivation skills with experience in working to tight deadlines
- Experience with other NoSQL databases like Hadoop, Cassandra
- Experience with NoSQL database technologies such as Apache Cassandra, MongoDB, HBase, CouchBase
- Bachelor Degree in Information Technology, Engineering, Computer Science, related field or equivalent experience
2
Database Admin Job Description
Job Description Example
Our company is looking to fill the role of database admin. 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 admin
- Assure the availability and performance of the various database environments
- Participate in disaster recovery exercise planning and execution
- Responsible for problem escalation to Oracle Support and third parties, as necessary
- Communicate with the customer through formal correspondence
- Participate in DBA peer review sessions with other team members
- Diagnose and solve complex problems including non-functional problems such as performance issues by identifying workarounds, and driving resolution /the problem
- Must be able to multi-task, prioritize, and work with multiple development and operations teams simultaneously
- Assist Build team with Environment requirements (Storage, OS, Database, MAC-Request IDs, Groups, and Firewalls )
- Will work independently with other teams to source data from upstream Enterprise, internal Global Markets systems
- Familiarity with tools like Oracle Enterprise Manager/Grid Control and AWR highly desired
Qualifications for database admin
- In depth understanding of Hadoop ecosystem like HDFS, YARN, MapReduce, Hive, Pig, Spark, Sqoop, Solr, kafka, oozie , Knox
- Minimum 7+ years of experience with UNIX shell scripts on SOLARIS
- Undergraduate degree and 4+ years of experience in administering Oracle Database Systems in a production environment, or Graduate degree and 2+ years of experience in administering Oracle Database Systems in a production environment
- Must have excellent written and verbal communication skills in the English language
- TSQL code reviews and walk-throughs
- General systems management and networking knowledge
3
Database Admin Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of database admin. 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 admin
- Notification Monitoring
- Provides business continuity planning for corporate databases
- Provide day-to-day application database administration support to multiple Integrated Operation programs
- Experience in addressing MULTI LOADS for Informatica using scripts, loading data into IDW and also experienced in building data sets for supporting data consumption
- With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc)
- In-depth knowledge of Teradata Explain and Visual Explain, data distribution among AMPs and index usage, collect statistics, revision of correlated sub queries, etc to analyze and improve query performance
- Provide Teradata design/implementation consulting
- Adhere to Data Warehouse architecture, standards and processes
- Knowledge of loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica
- Implementation of data and table-level security, setting up access rights and space rights for Teradata environment
Qualifications for database admin
- Thorough knowledge of business functions/business related policies
- Regularly contributes to the development of new business function/business related concepts, techniques, and standards
- Considered very knowledgeable in field within KP
- 6+ years of MySQL or Oracle database administration experience supporting 24x7 high volume Production OLTP databases
- 2+ years managing or leading database administrators, providing leadership and infrastructure support in the maintenance of large, complex data stores
- Ability to work independently collaborating within a team
4
Database Admin Job Description
Job Description Example
Our company is searching for experienced candidates for the position of database admin. 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 admin
- Analyze DBQL entries specific daily to identify long-running queries, high CPU and I/O usage, spool usage, noting accounts, assessing SQL for troubleshooting and provide recommendations
- Provides onshore on-call support for supporting offshore team
- Address database or performance issues that are forwarded from Customer Care
- Provide DBA support on all aspects of databases administration including backup/recovery, replication, deployment and real time production troubleshooting responsibilities on Oracle and DB2 UDB databases with DPF
- Provide Tier 4 / SME and on-call support for database servers and related infrastructure
- Responsible for the installation, administration, monitoring, and security of all MS-SQL databases for Watts PVI
- Monitors environment for performance issues and implements solutions to improve performance
- Designs and develop reports in SQL Server Reporting Services, SQL Server Analysis Services, BI Tools and BAQs in Epicor 10
- Performs analysis, design, testing, implementation and maintenance for highly complex projects
- Ensures the integrity of database files through the daily monitoring of database backups and logs.Ensure that deliverables meet or exceed functional, technical, and performance requirements
Qualifications for database admin
- Monitoring, optimizing and administration of Databases and Web Servers or applications that utilize databases and web servers
- Identify data requirements by working with variety of internal and external stakeholders to understand, assess, and provide solutions for the program's IT and data requirements
- Ensure database quality, maintain data availability, integrity and security including
- Expert level knowledge in Oracle
- Provides performance assessment and tuning as related to the operating system, the database, and disk subsystem
- Must have very strong proven track record of accomplishments and leadership
5
Database Admin Job Description
Job Description Example
Our innovative and growing company is looking for a database admin. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for database admin
- Develops solutions utilizing C# and other scripting tools within the Epicor Development and MS Visual Studio Environments
- Installation, configuration, management and monitoring of various database systems
- Database upgrades, scripting, task automation, backups/recovery
- Multi-tasking in a hosting and production support driven environment
- Install, configure, and upgrade database software
- Troubleshoot database issues, identify root cause, and recommend corrective action
- Configure database replication
- Setup disaster recovery environments
- Install, upgrade, and configure database software
- Implement and maintain complex database security
Qualifications for database admin
- Knowledge of Oracle E-business Suite and SAP will be an added advantage
- Comprehension of application development processes, methodologies and techniques
- Ability to be on call 24x7 support rotations
- Mentor junior or associate DBAs
- Thorough understanding of the relational database model and solid theoretical knowledge of relational database techniques
- Ideal candidate will have 4-6 years’ experience managing a DBA team supporting heterogeneous database environment of a financial industry