Database Admin Advisor Job Description
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:
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:
Desired experience for database admin advisor includes:
Database Admin Advisor Examples
Database Admin Advisor Job Description
- 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
- 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
Database Admin Advisor Job Description
- 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
- 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
Database Admin Advisor Job Description
- 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
- 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
Database Admin Advisor Job Description
- 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
- 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
Database Admin Advisor Job Description
- 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
- 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