DBA, Senior Job Description
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:
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:
Desired experience for DBA, senior includes:
DBA, Senior Examples
DBA, Senior Job Description
- 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
- 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
DBA, Senior Job Description
- 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
- 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
DBA, Senior Job Description
- 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
- 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
DBA, Senior Job Description
- 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
- 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
DBA, Senior Job Description
- 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
- 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