Administrator, Database Job Description
Administrator, Database Duties & Responsibilities
To write an effective administrator, database job description, begin by listing detailed duties, responsibilities and expectations. We have included administrator, database job description templates that you can modify and use.
Sample responsibilities for this position include:
Administrator, Database Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Administrator, Database
List any licenses or certifications required by the position: SQL, ITIL, MCTS, IAT, MCDBA, MCITP, CCNA, MTA, MCSA, MVP
Education for Administrator, Database
Typically a job would require a certain level of education.
Employers hiring for the administrator, database job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Associate Degree in Computer Science, Education, Technical, Engineering, Management, Technology, Business, Computer, Computer Engineering, Computer Information Systems
Skills for Administrator, Database
Desired skills for administrator, database include:
Desired experience for administrator, database includes:
Administrator, Database Examples
Administrator, Database Job Description
- Proactive monitoring and preventative action systems to avoid outages
- Performs capacity planning, workload modeling and prediction
- Implementation of change control requests during the change control window
- Maintains policies, standards, and procedures related to the database environment
- Translate a logical model into the physical database design
- Monitor data quality and assist programs with code and stored procedures
- Develop database monitoring and reporting solutions to track performance and provide resource forecasts
- Plan and implement system updates and migrations
- Help chart out long-term software development plans for database clients
- Work with TDs and engineers in production and technology to solve technical challenges and debug high-priority issues involving database-backed applications and services
- Will be required to work outside of normal business hours and/or extended as necessary
- This position supports business units functioning on a 24*7 calendar
- At least three years of experience as a SQL Server Production support DBA is required
- Knowledge of installing and configuring SQL Server databases (version SQL Server 2008 and above)
- Experience managing multiple SQL Server production databases in a 24*7 service environment
- Experience performing database backups complete and incomplete database recovery
Administrator, Database Job Description
- Act as a gatekeeper to databases, preserving their integrity and performance, reviewing schema change designs with engineers, and making recommendations for changes in a fast-paced environment
- Coordinate data sharing and migration work with other groups
- Provide database development support and troubleshooting
- Assist in architecting new systems and analyzing capacity and performance requirements
- Ensure backups of all production and mission-critical data are securely captured
- Work with dev ops to coordinate backup restoration process, database upgrades, etc
- Predict and resolve database storage, performance, application and job issues
- Monitor backup jobs on all databases and perform routine disaster recovery scenarios
- Establish and maintain database policies and standards
- Generate database schema definitions and modifications as required
- 2 plus years of Database Administration experience
- Proficiency in database design and administration
- Five or more years of experience with database management systems
- Eight or more years of experience in specific database management systems
- Working knowledge of functional and technical design, programming, query tools and testing components of application development
- Thorough knowledge of database management systems including experience with design, analysis, deployments, debugging, performance, transactional analysis, characteristics and recovery activities
Administrator, Database Job Description
- Work with the developers and analysts to develop a solution or enhance existing solution
- Provide DB services by responding to incoming issues and requests via tracking systems (Service-Now) and proactively monitoring system for problems
- DB installation, configuration and administration
- Automating deployments, creating DB scripts for backups
- Liaise with client infrastructure teams for physical DB administration, and deployments
- Apply database utilities, maintain the relationships between the database users and applications and maintain the organization's databases across multiple platforms and computing environments
- Serve as an independent contributor with expertise in at least one technical area
- Participate in the maintenance of existing database systems
- Administer the database platforms by executing routine processes
- Contribute to DBA policies and procedures
- Thorough knowledge of logical data modeling tools, SQL Server, Oracle, and supportive software
- Support application upgrades
- Database maintenance for development, test, and production environments
- Performance and Tuning of SQL
- Tuning of MSSQL and Oracle Database instances
- Participate in application testing and training as required
Administrator, Database Job Description
- Assists in application tuning
- Installs DBMS software
- Participates in future technology evaluations
- Ensures availability and performance of the enterprise databases
- Ensures improvement and maintenance of the databases including rollout and upgrades
- Implements and releases database changes related to business requirements
- Plans regular database capacity related to database growth and system utilization
- Pro-active and reactive monitoring, troubleshooting and resolution of issues
- Ensures implementation and maintenance of data flows between application systems
- Defines and implements consistent standards across database systems
- Must have knowledge of administration and configuration of SQL reporting service and SQL Analysis Server
- Must have excellent written and verbal communication skill to facilitate resolution of database issues with users
- Availability for night/weekend shifts or 24/7 on-call availability as required by the business
- Bachelor’s or Master’s degree in computer science or equivalent education and experience
- Manage production, staging and development database environments
- Create detailed documentation including diagrams of database infrastructure
Administrator, Database Job Description
- First-level resolution of database alerts
- Ensures synchronisation between production replica databases
- Runs or re-run failed regular jobs and kill failed tasks
- Implements regular monthly patches
- Troubleshoot database-related application performance issues and perform routine and proactive maintenance activities
- Support the software development and systems administration teams by providing insights into how to access and efficiently query multiple databases
- Input and update donor data and process donations in database of record
- Contact donors to gather information needed to update their records and process their donations
- Create and run file queries to support our ability to acknowledge gifts on a timely basis
- Conduct data imports and exports to ensure integration across multiple platforms
- Solid knowledge of Transact-SQL and SQL Server Profiler
- Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage
- 2 – 10 years experience in Database (Oracle, MS Sql, DB2, Sybase, mySQL) Administration
- 3+ years of DBA experience with RDBMS systems such as PostgreSQL and Oracle
- Familiarity with Amazon Web Services (EC2, RDS)
- Minimum of 3 to 5 years of experience with managing MSQ SQL/Sybase Databases