Vertica DBA

Hi All,

Kindly have a glance at the below requirement and send me your consultant's updated word copy of resume, contact details and competitive rate ASAP if he/she is a good fit.

Please submit the resumes to jay@ksourceinc.com

 

Vertica DBA

Location- Salt Lake City , UT

 

 

Description:

The Vertica Database Administrator (DBA) is responsible for architecting and operating the Vertica database clusters that form a critical component of Cotiviti's analytical platforms. You will install and maintain the software, implement backup and recovery processes, provide performance tuning and assist in business process integration with various data sources. You will work with a distributed team of IT and DBA resources and are also required to collaborate effectively with internal and external stakeholders to ensure that these database platforms are highly available, optimally configured and efficiently managed. This is a challenging role that demands strong technical leadership, communication, analytical and problem-solving skills.

Responsibilities:

• Plan, build, deploy and maintain enterprise OLTP and OLAP based EDW platforms and services. This includes proactive monitoring and tracking, and relevant data analysis and reporting.
• Pro-active and reactive performance analysis, monitoring, troubleshooting and root-cause analysis of database related issues in support of critical day-to-day business operations.
• Responsible for establishing and enforcing consistent database standards, access protocols, profiling and benchmarking, and development, execution and measurement of effective service level agreements.
• Responsible for database capacity planning and efficient utilization of database resources based on performance, growth and utilization trends.
• Responsible for ensuring high-availability (>99.0%) of critical database systems and services and development, implementation and testing of failover and recovery plans for all critical database systems.
• Participates in the setting of objectives, strategies, plans, programs, performance standards/measures and procedures, as a member of the IT leadership team.
• Participate in on-call system administration support including but not limited to weekends, holidays and after-business hours as required to service the needs of the business.
• Provide mentoring and guidance to junior technical team members.
• Completes all responsibilities as outlined on annual Performance Plan

Requirements:

• BS or MS Degree in Computer Science/MIS or technically related field with a minimum of 5 years relevant industry experience.
• Prior experience with Vertica Administration and expertise in VSQL. Good working knowledge of Vertica database architecture (column orientation, compression, projections, segmentations, partitions, high availability and recovery, security)
• Demonstrated thorough knowledge and progressively responsible experience in implementation and maintenance of large-scale OLTP and OLAP systems in mission-critical environments.
• Demonstrated in-depth knowledge of database internals and data structures. Hands-on experience with database optimization and tuning.
• Excellent hands-on expertise in SQL/SQL*Plus, PL/SQL, and Unix Shell or Perl scripting.
• Prior experience with third-party BI tools like Pentaho, Syncsort, Informatica etc. a plus. Knowledge of MPP and Hadoop data warehousing platforms a plus.
• Knowledge of formal information security standards and best practices, including database system hardening, identity management and database access controls. Knowledge of HIPAA and PCI standards a plus.
• Demonstrated project management skills and ability to track and report progress against established milestones, metrics and deliverables.
• Demonstrated verbal and written communications skills with strong customer service orientation.
• Positive attitude, ability to work in a team and ability to multi-task in a fast-paced environment with minimal supervision

Other Skills:

• Ability to work in a rapidly changing environment and willing to learn other database technologies (Oracle, Teradata, MSSQL, Cassandra, MongoDB)
• Database certifications will be advantage
• Prior experience with Vertica Administration and expertise in VSQL. Good working knowledge of Vertica database architecture (column orientation, compression, projections, segmentations, partitions, high availability and recovery, security)

Prior experience demonstrated thorough knowledge and progressively responsible experience in implementation and maintenance of large-scale OLTP and OLAP systems in mission-critical environments including, but not limited to, Oracle 11g/12c, Oracle RAC, Oracle Grid Control, Data Pump, Data Guard, Oracle Streams, Oracle Directory Services, Oracle Enterprise Manager, Oracle Cloud Control. Experience with Exadata is plus.

Thanks

Jay

--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sureshotjobs/CADO0ZGP4wwnPtp6-FOJSHpVPT4Y8hP9q2HaxoKT%3D6-Q5dQvQZg%40mail.gmail.com.