Senior Database Job Description
Senior database
provides coaching and guidance to application developers, ETL developers and data analysts regarding database methodologies, best practices on performance tuning, query optimization, index tuning, caching, buffer tuning, etc.
Senior Database Duties & Responsibilities
To write an effective senior database job description, begin by listing detailed duties, responsibilities and expectations. We have included senior database job description templates that you can modify and use.
Sample responsibilities for this position include:
Support software development process including SQL changes review to ensure optimized released to production and general DBA support for development and QA database environments
Assist end users with SQL query writing for optimal performance
Configuration, management, monitoring, maintenance and troubleshooting of SQL Server 2008 R2 and newer MSSQL databases
Manage SQL Clustered and high availability environments
Designs, creates and maintains highly available and high performing SQL Server databases
Develop and maintain T-SQL procedures, views, functions, and other scripts in support of product development, customer reporting, and database administration requirements
Execute Oracle 11g-12c upgrades installation, configuration and administration knowledge transfer to in-house clients so they can become self-sufficient
Write high performance SQL queries and stored procedures
Participate in 24x7 production support on a rotation basis
Respond to alerting systems in a timely manner and quickly be able to identify, troubleshoot and remediate problems
Senior Database Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Senior Database
List any licenses or certifications required by the position: SQL, MS, ITIL, DBA, HA, MCSE, MCSA, MCDBA, RDS, AWS
Education for Senior Database
Typically a job would require a certain level of education.
Employers hiring for the senior database 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, Engineering, Education, Technical, Information Technology, Software Engineering, Information Systems, Administration, Management Information Systems, Management
Skills for Senior Database
Desired skills for senior database include:
Linux
SQL
UNIX
Oracle
Index management
Storage
Recovery models
Query Tuning and Optimization
Schema Design
Indexes
Desired experience for senior database includes:
5+ years of direct experience developing in MSSQL
Automate and innovate new ways to manage large database clusters
Create sustainable and maintainable environments
Collaborate with Engineers and System Administrators on technical issues
Be part of the community
2+ years managing highly available production systems
Senior Database Examples
1
Senior Database Job Description
Job Description Example
Our company is growing rapidly and is hiring for a senior database. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for senior database
- Provide detailed monitoring of jobs and logs for Oracle, My SQL, and SQL Server and Servers
- Experience with MySQL, SQL Server or Oracle is preferred
- The ability to respond to pages within time determined by SLA, handle entry level database tasks for Oracle, MySQL, and SQL Server, escalate all other pages to appropriate person (training provided for database tasks)
- Own ETL infrastructure - Provide technical leadership and ownership (design, build, document, enhance and operational support) for all components of SQL ETL processes(SQL code, scheduling, monitoring/alerting etc), for all platforms - Peoplesoft, Salesforce, Amazon Redshift, Tableau Design and build databases as necessary
- Respond to issues within time determined by SLA, handle entry level database tasks for Postgres and SQL Server
- Support Enterprise reporting - Collaborate with reporting analysts to support GSB’s OBIEE reports and underlying SQL infrastructure
- Support analysts - Design and build appropriate SQL integration components required by Tableau dashboard developers to build dashboards
- Support EDI / EAI - Build SQL integration components and provide business background and general technical data-relevant support to engineers working on various application platforms - Salesforce, mobile, Java
- Performs activities related to day-to-day administration and maintenance of Microsoft SQL databases
- Monitor database server capacity/performance and make infrastructure and architecture recommendations to management for necessary changes/updates
Qualifications for senior database
- Ability to write business case proposals and make presentations to diverse audiences
- Replication (GoldenGate and Dataguard)
- Flexible and Comfortable with uncertainty in requirements in a fast paced, rapidly changing environment
- A minimum of 5 years of experience in database administration and support in Oracle and 2 years in Hadoop (HDFS) environments
- Strong familiarity with data access technologies and protocols, such as ODBC, OLEDB, ADO.NET, LINQ to SQL, Entity Framework, JDBC, Hibernate/NHibernate
- Hands on experience with database load testing and Data Access Layers in C# or Java
2
Senior Database Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of senior database. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for senior database
- Provide escalation support for database related issues
- Assist in the design and implementation of internal database applications
- Assist in the implementation and management of metadata systems
- Assist with design of the Data Warehouse to ensure system availability and optimal performance of queries against the Data Warehouse
- Maintain documentation in Word and Excel ServiceNow workload management system
- Candidate will have access to work and support larger MMP Database Clusters which are spread across hundreds of physical machines as skill set increases
- Responsible for maintaining the Big Brother and SolarWinds monitoring tools
- Responsible for driving customer satisfaction by continuing to deliver support excellence with your willingness to listen, understand, and anticipate our customers’ needs
- Re-architect the system (i.e., design/develop/implement system improvements to the user interfaces, ETL processes, database structure)
- Interact with customers, users and third parties as appropriate
Qualifications for senior database
- Bachelor’s degree in Computer Science, Information Technology, or Business or equivalent OR High School diploma with 8+ years equivalent work experience
- A true passion for Technology
- A minimum of 7 years of experience in database administration and support in Oracle versions 10g through 12c
- Expertise needed setting up, monitoring and troubleshooting Oracle Golden Gate
- Expertise with physical and logical schema design and troubleshoot common issues
- Ability to be on call production support on a rotation basis
3
Senior Database Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of senior database. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for senior database
- Writing efficient T-SQL for 20+TB of data
- Be part of a fast-paced, highly technical development team responsible for developing and delivering SaaS solutions to HR organizations
- Lead database and reporting development projects and ensure successful project delivery
- Participate in all phases of delivery including business/system analysis, data architecture, development, test, deployment, and support
- Take on production DBA responsibilities
- Architect, design, and develop database and reporting systems and subsystems while taking into consideration business needs, integration, quality, and performance
- Work closely with business stakeholders to help define and execute data requirements
- Troubleshoot complex issues during the project and provide solutions to solve them
- Provide support to production
- Research and champion new technologies and approaches
Qualifications for senior database
- Advanced knowledge of SQL Server, SSRS, SSAS, ODS, EDW and/or other data collection and presentment applications
- Research new technologies to propose and inform both improvements to existing infrastructure, the implementation of future capabilities
- Familiarity with distributed NoSQL databases and their applicability (Redis, Cassandra, Riak, MongoDB)
- DE troubleshooting real-time mission critical database applications using Oracle Enterprise Manager version 12c
- Bachelor’s degree in Computer Science, Information Technology, or Business or equivalent or
- Knowledge of 3rd party DBA tools and applications Idera or Foglight tool suites
4
Senior Database Job Description
Job Description Example
Our growing company is hiring for a senior database. 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 senior database
- Provide on-site, and on-call support, as needed
- Identifying, defining and implementing database backup / recovery and security strategies
- Architecture and designing of enterprise databases and data warehouse
- Hands on senior developer with strong abstraction, analytical and problem solving skills
- Ability to design prototypes that augment existing system
- Forward thinking, proactive approach to monitoring all databases
- Ability to provide accurate resource and capacity planning
- Manage backup and disaster recovery plans for all databases
- Participate in implementation, testing, deployment and integration with various third-party applications
- Responsible for setup and monitoring of routine database maintenance scripts
Qualifications for senior database
- SQL Server or Postgres administration and replication experience a plus
- Or client server environment required
- Excellence in breadth of technical skills and technical knowledge required respective to various mainframe or client server programming development environments
- Strong skills required in leadership, critical thinking and analysis, verbal and written communications, and interpersonal interactions
- Design and maintain a large clinical SQL Server Database
- Tuning SQL Server Databases
5
Senior Database Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of senior database. 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 senior database
- Evaluate releases of SQL Server and its tools
- Perform administration of all database objects, including tables, clusters, indexes, views, sequences, packages and procedures
- Participate in system testing, integration testing, and review/development of business training materials
- Remain abreast of current technologies and best practices
- May be heavily involved in design and execution of reports and report development
- Responsible for working closely with development teams to design, implement and support our products database and reporting systems
- Provide quality solutions for database issues raised from Clients in a timely manner, and assist with the continual improvement of operational processes and procedures
- Contribute to C# .Net platform development as required
- Creates and maintains all databases required for development, testing, education and production usage
- While working closely with systems administration staff, perform capacity planning required to create and maintain databases
Qualifications for senior database
- Design and code a large number of SQL Queries and stored procedures
- Monitor and perform tuning on large ETL jobs
- Assure the quality of the new Data Warehouse
- Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment
- 3+ years of experience with developing databases in an Agile framework with constantly changing technical requirements
- Amazon Web Services (AWS) Certification, including Certified Solutions Architect, Certified Developer, Certified SysOps Administrator, or Certified DevOps Engineer