DBA, Senior Job Description
DBA, senior
provides expertise in High Availability (Clustering) solutions, replication technologies, SQL tuning, backup and recovery support, installation of Oracle software and configuration, apply patches, unix shell scripting, partitioning of tables and indexes, partition maintenances, archiving of data, capacity planning, complex security architectures and have basic unix administration skills.
DBA, Senior Duties & Responsibilities
To write an effective DBA, senior job description, begin by listing detailed duties, responsibilities and expectations. We have included DBA, senior job description templates that you can modify and use.
Sample responsibilities for this position include:
Writing SQL queries, stored procedures, scheduled jobs
Assisting the development teams (ERP, CRM and Web) by writing high performance, low impact T-SQL code and optimising existing T-SQL where necessary
Designing , administering and supporting the underlying SQL database for Archer
Creating and scheduling SQL server jobs for automatic updates
Analyse and resolve SQL Server-related database incidents and problems, hardware or other IT systems related issues
Perform SQL Server-related database customer delivery and demand requests (scripts, recoveries)
Create scripts and T-SQL packages for data integration, data maintenance or bug fixes
Write SQL statements for ad-hoc report generation or corrective actions
Write and troubleshoot SQL Code and design (stored procedure, functions )
Research and implement tools to monitor SQL performance and recommend optimizations to increase performance
DBA, Senior Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for DBA, Senior
List any licenses or certifications required by the position: SQL, DBA, OCP, OCA, MCDBA, MS, MCSE, MCITP, MCSA, SSL
Education for DBA, Senior
Typically a job would require a certain level of education.
Employers hiring for the DBA, senior 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, Technical, Education, Information Technology, Information Systems, Design, Communication, Business, Computer
Skills for DBA, Senior
Desired skills for DBA, senior include:
New products released in the market for supported product
Oracle’s current and future products/ solutions offerings
GNC environment and GNC services
Load balancing and high availability planning
Ad-hoc queries
Perl
Procedures
SQL
Unix Shell Scripting
Weblogic/application administration and expertise in supporting Linux server applications
Desired experience for DBA, senior includes:
Expert level skills on Teradata
Hands on experience in data modeling
Configuring the RSA Archer platform and develop applications based on technical requirements using standard designs
Work with functional resources to understand requirements and ensure clean data is inputted within the Archer master database
Write and manage interfaces between the Archer database and other data sources
Experienced with Sybase ASE 12.5, 15.0 and 15.7
DBA, Senior Examples
1
DBA, Senior Job Description
Job Description Example
Our innovative and growing company is hiring for a DBA, senior. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for DBA, senior
- Tune SQL code and assisting developers in writing and tuning SQL queries
- Requires significant experience in architecting and supporting NO-SQL databases in large project environments
- Act as the functional expert for SQL Server architecture and best practice
- Understand SAN based storage and related technologies, specifically as applicable and useful to MS SQL Server installations
- Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, in accordance with change control policies
- Manage and support 40+ MS SQL production databases
- Plan, test, and install upgrades/patches for MS SQL server as necessary
- Develop and administer backup and recovery procedures
- Assist with the design and implementation of the Relativity systems and database infrastructure, including hardware and software environment, and all related systems architecture
- Be the primary point of escalation from customers and/or team members for all Relativity systems performance related issues
Qualifications for DBA, senior
- Experienced with VCS (Veritas clustering)
- Proactively engage with customers and team members to address issues prior to escalation
- Work with kCura technical support as required to resolve software related issues which cannot be solved locally
- Analyse, define and write system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configuration
- Proactively conduct research and make recommendations on future systems upgrades, including database adjustments and optimizations, new products, services, protocols, development efforts
- Analyse code for problem resolution and performance optimizations
2
DBA, Senior Job Description
Job Description Example
Our growing company is looking for a DBA, senior. 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 DBA, senior
- Responsible for installation, configuration, maintenance, and patching procedures
- Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases and systems
- Be available 24x7 for support escalations, as required during off-hours
- Assist with sales and pre-sales related activities (RFPs, sales presentations)
- Work closely with other XLS delivery teams, including processing and systems teams to ensure project requirements, timelines and objectives are met
- Engage regularly with key clients directly to ensure projects are progressing properly and are meeting expectations
- Work to establish scalable support team structures and solutions (help desks, knowledgebase, ) to provide outstanding service in a cost-effective manner
- Provide regular status updates to all stakeholders at appropriate intervals including customers Business Development and Senior Management teams
- Knowledge on Unix Replication technologies like SRDF , HVR is desirable
- General backup
Qualifications for DBA, senior
- Database cloning, RMAN cloning, Active database cloning
- Exposure to leading a team in a matrix management environment
- Have the ability to develop a technical team
- Experience with scripting in Windows or with PowerShell
- 5+ years of experience in Oracle 11g-12c database administration, design and development with large mission critical databases in a real time production environment
- Oracle 12c Multi-tenant
3
DBA, Senior Job Description
Job Description Example
Our company is growing rapidly and is looking for a DBA, senior. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for DBA, senior
- Provide support for software developers by providing guidance on the development of SQL queries, vetting, and tuning them where needed
- Develop and support databased stored procedures
- Responsible for the backup and recovery strategy and monitoring of production systems
- Monitoring performance on production systems and recommending changes for improvements
- Monitoring and troubleshooting skills encompassing the “big picture” environment of databases, operating systems, applications, app servers, networks
- Collaborate with engineering and systems teams on service delivery and support
- Take ownership of projects and systems as needed
- Install, configure, monitor and maintain databases in the production, development, and quality assurance environments
- Analyze problems, anticipate future problem areas and implement solutions
- Provide response for all database issues
Qualifications for DBA, senior
- In-depth knowledge in either MySQL or MongoDB
- At least 4 years of hands-on experience with database administration, tuning, management, security and backup
- Ability to troubleshoot and resolve database issues
- Exceptional problem solving and decision making capabilities, including troubleshooting technical issues, successfully resolving project issues and challenges, and developing creative solutions for process improvement and understanding user requirements
- Implementation of Backup/Restore and DR strategies
- SSRS infrastructure
4
DBA, Senior Job Description
Job Description Example
Our company is looking to fill the role of DBA, senior. 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 DBA, senior
- With a focus on best practices, assists with establishing standards and procedures for monitoring, maintenance and troubleshooting of database systems
- Monitor, restart and maintain of SQL Server databases
- Compose SQL scripts to provide critical information to stakeholders and management
- Monitor SQL server, application, and security error logs for any abnormalities
- Design, develop, test, and maintain database solutions using MS SQL server and related applications
- Design and deploy Integration service packages using SQL Server data tools
- Search out and implement new technologies to continually simplify the environment while improving security, scalability, availability, and performance
- Optimize database accessibility by developing load balancing/high availability architectures and processes to eliminate down time
- Develop scripts for database monitoring and to automate routine tasks
- Perform data management tasks as required, such as loading, restoring and moving data to support our client implementation teams
Qualifications for DBA, senior
- Other database technologies (Oracle, MySQL)
- DB performance tuning with Microsoft Dynamics AX
- Accountability – Holds self and others accountable to meet commitments
- Collaborates– Builds partnerships and works collaboratively with others
- Drives Results– Consistently achieves results, takes on new opportunities and tough challenges
- Innovation – Creates new and better ways for the organisation to be more successful
5
DBA, Senior Job Description
Job Description Example
Our innovative and growing company is hiring for a DBA, senior. 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 DBA, senior
- Storage, Jobs and Backup management
- Develop and maintain solutions using SSIS, specifically ETL operations
- Maintain SSRS report server to support reporting team
- Some Stored Procedure, Trigger and View development
- After hours on call support for production issues will be required
- Creates new database objects, and dictionaries
- Consults with senior management to develop and promote database strategies and programs to meet the company's future needs
- Responsible for planning and upgrading of major and complex application and database upgrades
- Work with the rest of the DB team to maintain, improve and document existing databases and applications
- Work with the software development team to optimize DB performance
Qualifications for DBA, senior
- Design, Interpret, and Modify detailed database designs
- Must have 7-10 years of demonstrating solid Oracle Database Administrator skills in a RAC environment with Replication to multiple RAC Databases
- Must have 7-10 years of experience with Unix/Linux knowledge including Shell scripting
- 5 years of experience with Data Warehousing with multiple terabyte databases
- Knowledge of Oracle Failover and Disaster Recovery with Data Guard
- Experience setting up backups executing RMAN backups using Third party tape mgt systems