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 j...@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