COTIVITI NEPAL

COTIVITI NEPAL

Software Industry

Kathmandu

Established in 2004, Cotiviti Nepal Pvt. Ltd. is a leading American Software company in Nepal. We are proud team of around 300 professionals who are involved in the design, development, testing and maintenance of impressive lineup of trend-setting healthcare informatics solutions. Besides that, our talented people sort and analyze voluminous data to help clients in decision analytics.  We are one of the eight centers of Cotiviti Inc. which opera ... tes from seven more locations across United States of America and constantly ranked among the best healthcare informatics companies. In Nepal, Cotiviti Nepal Pvt. Ltd. has its remarkable identity in the software industry. At the core of our works, we offer risk-assessment services and decision analytics in the area of healthcare that help customers better understand and manage their risk. We strive to help our clients focus on their businesses while we concentrate on optimizing quality by focussing on the followings- Employee growth and development Work culture/environment Team work – Collaboration Process Exposure to latest and greatest technologies and tools  

View Company Profile

Senior Database Admin (MSSQL)

Apply Before : 2024-02-16 (Closed) View: 5220

Job summary

  • No. of Vacancy
    : 5
  • Job Type
    : Full Time
  • Offered Salary
    : Negotiable
  • Gender
    : Both
  • Career Level
    : Mid Level
  • Experience
    : 5 Years
  • Apply Before
    : 2024-02-16 Closed

Job Description:

This position is for a Sr Database Admin. The successful candidate will maintain database environments in an enterprise. You will work with a distributed team of Database Administrators to manage and support key enterprise database systems that provide critical data processing services to internal and client-facing business applications and services. These database systems are primarily based on Microsoft SQL Server, Oracle & Vertica technologies but may evolve to include other data warehousing solutions in near future. You will be required to collaborate effectively with internal and external stakeholders to ensure that these database platforms are highly available, optimally configured and efficiently managed, and for the operational support of large production EDW systems. This is an extremely challenging role that demands strong technical leadership, communication, analytical and problem-solving skills.

Responsibilities:

  • Manage SQL Server OLTP, OLAP databases through multiple product lifecycle environments, from development to mission-critical production systems.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Perform data modeling, database design, master data management, and data profiling in a large-scale OLTP and OLAP database environments
  • Analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
  • Refine and automate regular processes, track issues, and document changes
  • Perform scheduled maintenance and support release deployment activities after hours.
  • SQL performance tuning of Database software installation, configuration, upgrade and maintenance activities
  • Automate database administration tasks such as creating and migrating databases
  • 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.
  • Develop and implement plans for database consolidation where needed
  • Create and maintain user accounts where applicable
  • Maintain documentation of SQL server databases and systems
  • Assist with application implementations
  • Work with end users for special requests and new setups
  • Apply functional patches when needed
  • Provide mentoring and guidance to junior technical team members.
  • Complete all responsibilities as outlined on annual Performance Plan.
  • Complete all special projects and other duties as assigned.
  • Must be able to perform duties with or without reasonable accommodation.

Required Knowledge, Skills, and Abilities:

  • Working knowledge of basic system administration on Windows server including Active Directory
  • Preferred prior good experience with recent and newer versions of database platforms, database virtualization, clustering, always-on availability, replications and database backup and recovery solutions.
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and 3rd party troubleshooting tools
  • Experience with backups, restores and
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Experience in writing SQL queries and some ANSI SQL preferred
  • Knowledge of batch, PowerShell and/or other scripting languages
  • Ability to organize and plan work in team and independently
  • Excellent interpersonal verbal and written communication and teamwork skills with strong customer service orientation
  • Experience using MS Office tools (excel, access, word)
  • 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.
  • 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, Vertica, etc.)
  • MCTS, MCITP, and/or MVP certifications will be advantage
  • 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, MSSQL SSMS, SSAS, SSIS, SSRS, 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.
  • 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)

Education + Experience:

  • Bachelor’s in Computer Science or equivalent
  • At least 5 years of experience managing database servers and databases

Apply Instruction:

Interested candidates fulfilling the mentioned criteria are encouraged to Apply using the Easy Apply Button below. Registered candidates may also apply using Apply Now Button.