MultiPlan SQL Database Administrator (IT Managed Care) JOB DESCRIPTION Database Administrators are you looking for a rewarding new position with an industry leader with a firm commitment to its employees? Join our team at MultiPlan Founded in 1980, we are the industry's most comprehensive provider of healthcare cost management solutions. We have almost 1,000,000 healthcare providers under contract, an estimated 68 million consumers accessing our network products, and 40 million claims reduced through our network and non-network solutions each year. We are currently seeking a contract (W2) SQL Database Administrator to work in our New York City office. We offer competitive compensation as well as a collegial workplace in a business-casual dress environment. This contract will last approximately 6-9 months with the possibility of conversion in 2020. JOB RESPONSIBILITIES As a SQL Database Administrator, you will require hands on SQL Database Administration (DBA) in HADR environment, multiple clustered servers and daily DBA activities. Your specific duties in this role will include: Manage database design, creation, and maintenance. Analyze database requirements of the user department, applications programming, and operations. Submit recommendations for solutions that require definition of the physical structure and functional capabilities of databases and require data security and data backup/recovery. Perform performance tuning, capacity planning, and back-up/recovery activities. Coordinate research, planning and implementation of new database installations, upgrades and patches. Control system capacity for existing requirements and plan for future needs. Facilitate root cause analysis on database issues. Maintain technical documentation relating to database management. Provide 24/7 production support on a rotation basis. Review/audit overall system security and data integrity. Define and develop a database monitoring facility. Identify and resolve all database performance issues. Act as a subject matter expert for less experienced team members. Collaborate, coordinate, and communicate across disciplines and departments. Ensure compliance with HIPAA regulations and requirements. Demonstrate commitment to the Company's core values. The position responsibilities outlined above are in no way to be construed as all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary. JOB REQUIREMENTS As a SQL Database Administrator, you must be highly organized and detail-oriented, with strong analytical, problem solving, and prioritization skills. You should also be able to handle multiple tasks in a fast-paced, deadline-driven environment, both independently and as part of a team. It is also important that you display excellent verbal and written communication and interpersonal skills, as well as the ability to effectively present information and respond to questions from groups of managers and clients Specific qualifications for the role include: Minimum Bachelor's degree in Computer Science, Information Technology, related engineering discipline or five (5) years of related experience Minimum 5 years of MS SQL DBA experience, including database design and implementation, administration of multiple SQL instances, Always On, SQL Clustering. SSRS, SSAS, Machine Learning, Change Data Capture is required. Extensive experience in installation, configuration and administration of SQL Server 2012, 2014, 2016 and 2017 More than 5 years of experience as Sr. SQL Database Administrator on Windows 2012 and above. 24/7 Production support of the databases and round-the-clock database operations SQL DBA activities include but not limited to Installation, configuration, importing/exporting, patch installs, capacity planning, backup and recovery of mission critical databases Support 200 SQL servers and 500 databases in clustering/HADR environment (A/A, A/P) and databases 1 TB in size Import and export data (Dev to QA, SQA, REG, EDI and Prod) Act as lead for migrating SQL Server to higher versions. Implement recovery plan to a point in time failure Responsible for data security and Integrity with HIPAA requirements Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, SSIS, Log shipping, Database Mirroring, SQL Mail, database mail Responsible for establishing best practices, standards and enforcing security mechanism Ability to troubleshoot day-to-day problems encountered on production as well as development database environments Experience writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes Excellent analytical, communication skills, work ethics and ability to work in a team environment with strong determination and commitment to the deliverables Knowledge of Solar winds, Golden Gate, Data Guard, Oracle Recovery Manager (RMAN) and data modeling experience is a plus. As an Equal Opportunity Employer, the Company will provide equal consideration to all employees and job candidates without regard to sex, age, race, marital status, sexual orientation, religion, national origin, citizenship status, physical or mental disability, political affiliation, service in the Armed Forces of the United States, or any other characteristic protected by federal, state, or local law. Associated topics: data analytic, data architect, data engineer, data integrity, data warehousing, database, hbase, mongo database, mongo database administrator, teradata
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.