Database Admin Advisor Job Description
Database admin advisor
provides support for backup/recovery of Oracle databases using rman, and ensure ongoing integrity of backup/recovery process for all customer-facing database environments.
Database Admin Advisor Duties & Responsibilities
To write an effective database admin advisor job description, begin by listing detailed duties, responsibilities and expectations. We have included database admin advisor job description templates that you can modify and use.
Sample responsibilities for this position include:
Pro-Active Maintenance of production test and development environments
Provides production database support with specific focus on availability, capacity, performance, security and recoverability
Establishes corporate standards for disaster recovery, data retention and database security and monitors industry standards
Performs project management tasks, including estimation, status reports and scope management
Determines database requirements for Lights On/production projects and ensures that new systems comply with database strategies
Provides implementation and ongoing support of databases in production
Translates detailed design into physical database structures and performs database testing
Builds and supports required database test environments
Provides technical expertise in troubleshooting and DBMS configuration
Provides 24x7 production and non-production DBA on-call support
Database Admin Advisor Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Database Admin Advisor
List any licenses or certifications required by the position: ITIL
Education for Database Admin Advisor
Typically a job would require a certain level of education.
Employers hiring for the database admin advisor 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, Administration, Education, Information Systems, Technical, Information Management, Engineering, Communication, Design, Business
Skills for Database Admin Advisor
Desired skills for database admin advisor include:
Storage subsystems
Experience with Microsoft Reporting Services
ITIL processes on Change Management
Incident Management and ITIL Process related activities
MS DB backup and recovery scenarios
NT scripting and windows OS are
Network and storage
Oracle backup and recovery scenarios
Physical database design
Physical database design and Partition Tables
Desired experience for database admin advisor includes:
Expert in Optimizing Databases/database servers, Backup/Recovery (point-in-time recovery), Security architecture, I/O sub-system tuning for best performance (data file layout, RAID configuration ), various trace flag settings and performance-tuning of database SQL code (procedures/packages )
This person will be responsible for mission critical production databases support that need to be available 7x24
Requires BS/BA degree in computer science or information systems or related field
Provide on-going and proactive performance tuning of existing and new database applications
Undergraduate degree in a technical field (such as computer science or engineering) is preferred, but not required
Utilize strong database administration experience and technical expertise for 24x7 monitoring and management of a large number of Cassandra, MySQL & MS SQL instances with large data sets unique networking set-ups
Database Admin Advisor Examples
1
Database Admin Advisor Job Description
Job Description Example
Our company is growing rapidly and is looking for a database admin advisor. 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 advisor
- Using monitoring and management tools
- Determines database requirements for projects and ensures that new systems comply with database strategies
- Provides implementation and ongoing support
- Works closely with our customers - Development, QA testers, Architects, Operations, Business Analysts and other staff to implement Database Administration changes and service requests
- Works with data modeler and coordinates with our customers to implement physical model on an ongoing basis
- Participates within the DBA team to troubleshoot any issues on the Netezza appliance, including any errors or slow running queries
- Builds and supports all required database environments including development, test and production
- Provides guidance to Development in best architectural practices in maximizing the database performance
- Plans, coordinates and implements database changes and data migration
- Conducts capacity planning on a regular basis to ensure database infrastructure is available and there is proactive planning for future work
Qualifications for database admin advisor
- Experience with a variety of file formats (XML, JSON, unstructured data)
- Significant experience in Unix/Linux environment
- Significant experience with at least three of these
- Work with appliance vendor to troubleshoot issues, perform upgrades, create and follow-up on support tickets as needed
- Actively monitors the user queries and maintenance occurring on the Netezza appliances, automating the monitoring where possible
- Conducts admin tasks including task estimation, creating status reports and leading team meetings
2
Database Admin Advisor Job Description
Job Description Example
Our growing company is hiring for a database admin advisor. 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 database admin advisor
- Perform day-to-day operational support of our Hadoop, Elasticsearch, SOLR, and MAPR clusters by monitoring their health and status, using Cloudera Manager, Marvel, and Nagios
- Assist other IT teams with routine application support at our clusters' edge
- Respond to health alerts generated by Cloudera Manager, Marvel, and Nagios
- Respond to emergency incidents and standard support requests, working them through to completion within established SLA
- Collaborate with multiple internal teams to resolve incidents and support requests
- Participate on any additional projects, assignments, or initiatives assigned by management
- Collaborate with peers on complex projects as assigned
- Review application performance trends and take appropriate action on issues of concern
- Update and manage configurations of our Hadoop clusters, including lab and production systems, primarily using Cloudera Manager
- Update and manage configurations of our Elasticsearch clusters, including lab and production systems
Qualifications for database admin advisor
- Must be organized and be able to put ideas into a tangible form
- Expertise in Oracle performance tuning Very Large Databases (VLDBs) and expertise with GRID controls to manage, monitor and administer oracle databases
- Proficiency in Optimizing Databases/database servers, Backup/Recovery (point-in-time recovery), Security architecture, Oracle Standby, Database clusters, I/O sub-system tuning for best performance (data file layout, RAID configuration ), various trace flag settings and performance-tuning of database SQL code (procedures/packages )
- Install Cloudera software packages and CDH parcels using Cloudera Manager and RedHat Satellite
- Install Elasticsearch software packages using RedHat Satellite
- Create and maintain documentation for operational procedures
3
Database Admin Advisor Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of database admin advisor. 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 advisor
- Work flexible hours during maintenance windows to avoid impact to production systems
- Participate in an active on-call rotation to provide after-hours response for critical service delivery incidents
- Works with senior Business and IT partners to identify, prioritize and lead the development and implementation of Database Administration standards, policies, methods, and procedures building consensus with all parties
- Leads highly complex Database Administration projects and efforts
- Oversees physical database creation and maintenance in production and non-production environments
- Accurately estimates Database Administration effort for any size project covering the projects database needs
- Identifies and defines standard procedures and processes, ensuring compatibility with vision and direction
- Works with Business and IT partners to identify, translate, and prioritize the most complex database architectural requirements
- Instrumental in providing guidance to subordinates in best architectural practices in maximizing the database performance
- Troubleshoots the most difficult database problems, recognized expert and go-to person
Qualifications for database admin advisor
- Hadoop certification - HDPCA or CCAH - or equivalent administration experience
- 7 + years industry experience in Information Systems
- 7 + years experience in Database Administration or related disciplines
- Demonstrated leadership ability with any size groups and superior communication skills
- Experience and demonstrated proficiency utilizing DBMS system management tools and demonstrated proficiency implementing the majority of new DBMS features and functionality preferred
- Experience in utilizing DBMS systems management tools and implementing new features and functionality preferred
4
Database Admin Advisor Job Description
Job Description Example
Our growing company is looking for a database admin advisor. 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 advisor
- Builds database structures based on detailed design
- Designs databases and ensures database design complies with database strategies
- Performs database testing, tracks and corrects defects and performs re-tests
- Determines Database requirements for projects
- Provides user management and DBMS security support
- Main responsibilities are a Production Support Role including Performance Monitoring, Automation Opportunities, Data Security and Restoration and Resiliency positioning
- This Production Support Role will include 24/7 support and inclusion into an on-call rotation schedule
- Database monitoring as to health-check (performance, space, backups...) will be a daily responsibility and working with the customer community for any required responsive actions
- Develops database designs based on business requirements
- Reviews and revises database designs and ensures that all technical and business requirements are met
Qualifications for database admin advisor
- Ability to solve large data volume issues inside Elasticsearch, using best practices to diagnose and scale the cluster to meet search SLA
- Interpret Elasticsearch service logs
- Create and run example searches using the REST API (including Sense)
- ITIL Foundations, including Change Management and Incident Management
- Scripting languages, including bash, Perl, and Python
- Well-spoken and articulate, combining attention to detail with excellent writing abilities
5
Database Admin Advisor Job Description
Job Description Example
Our company is looking for a database admin advisor. 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 database admin advisor
- Experience in Exadata, Delphix, Golden Gate, 12C are plus
- As part of leadership skills person should be able to run whole project as his own with interaction of multiple teams and resolving issues across the teams
- Self-motivated, Self-learner and self-driven
- Proficiency in utilizing DBMS system management tools and implementation of new features and functionality preferred
- Provide Database Support of databases in accordance with NTT Total Quality Management, SLAs and IT best practices
- Perform incident and problem queue management
- Accomplishes assigned tasks using metadata repository architecture
- Troubleshoots SAP Sybase ASE repository problems developers code with help from others
- Participates in quality reviews and the implementation, upgrade and maintenance of vendor supplied metadata management, master data management and information quality with SAP Sybase or other third party software
- Creates and maintains DBA documentation
Qualifications for database admin advisor
- Must have experience troubleshooting MS SQL issues
- Must have experience in SSIS
- Undergraduate degree and 5+ years of experience in administering SQL Server Database Systems in a production environment
- Requires BS/BA in Computer Science or Information Technology
- DB2 V11 / V12, UTS, IBM Utilities
- Requires BA/BS in Computer Science, Information Systems, BS of Engineering, Electrical Engineering, Civil Engineering or related field