Hi, Greetings From Ampstek !!
We are a Global staffing firm and we are Tier 1 vendor for all requirements and we can close positions immediately.
Please review our job opening below and kindly send us the updated resume ASAP along with the details of consultants; DOB & Passport Copy is mandatory for all submissions as BGC is compulsory with the end client.
Vertica DBA Salt Lake City , UT 12+ Months 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
Riya Raj Account Lead Ampstek Email: riya@ampstek.com (609) 297-0515 | | See what's happening on our social sites | | | | | | |
|
