jobholds
Principal Database Administrator
United States
•
Posted: 2022-02-16
•
58 Views
Job Overview & Requirements
Job Overview In this role, you’ll take on projects driven by direct customer requests, developing SQL queries and working directly with the database server. In this role, you’ll conduct proactive analysis of our data to ensure our databases are running optimally, performing corrective action of poor running SQL statements. You’ll troubleshoot the application, systems, and business process as related to the database, and work with our Development team to identify and resolve issues. About Us When you join iCIMS, you join the team helping global companies transform business and the world through the power of talent. Our customers do amazing things: design rocket ships, create vaccines, deliver consumer goods globally, overnight, with a smile. As the Talent Cloud company, we empower these organizations to attract, engage, hire, and advance the right talent. We’re passionate about helping companies build a diverse, winning workforce and about building our home team. We're dedicated to fostering an inclusive, purpose-driven, and innovative work environment where everyone belongs. Responsibilities Advanced troubleshooting of application, systems and business processes as related to the database Perform analysis/corrective action of poor running SQL statements Engineer hardware solutions in Amazon AWS for database infrastructure needs Ensure database environment is secure Create robust DR/Backup/Restore plans that reinforces current business RPO and RTO Create processes that are used for daily operation of database environment Ability to cover rotating off-hour/weekend support requirements Leads and participates in the patch, upgrades and product release efforts and on-call rotation support. Analyze issues logically and methodically with a strong attention to detail. Work with Development team to identify and resolve issues within applications to ensure successful release of products and updates. Act as a mentor to DBA I and II Consistently ensure that business is conducted with integrity at all times and that behavior aligns with iCIMS policies, procedures, and core competencies Qualifications Minimum of 5 years of database administration experience supporting a production SQL Server environment including a strong knowledge of high availability technologies Experience installing, configuring, and troubleshooting AlwaysOn Availability Groups and Windows Failover Clustering Strong knowledge of RDBMS concepts, specifically Microsoft SQL Server Able to automate routine processes using scripting, PowerShell, TSQL, etc. Experience with Amazon AWS, specifically MSSQL running on EC2 and RDS. Full life-cycle database experience including design, development, testing, deployment, and maintenance Ability to proactively recommend infrastructure upgrades based on trending analysis for future growth Excellent communication and interpersonal skills. Articulates thoughts and ideas clearly, concisely, and persuasively Ability to work effectively within a fast paced, changing environment that is going through high growth A self-starter with the demonstrated ability to take initiative, who can proactively identify issues/opportunities and recommend actions Bachelor’s degree in computer related field or 7+ years working with MS SQL Server Preferred Knowledge of MySQL, PostgreSQL and Aurora EEO Statement iCIMS is a place where everyone belongs. We celebrate diversity and are committed to creating an inclusive environment for all employees. Our approach helps us to build a winning team that represents a variety of backgrounds, perspectives, and abilities. So, regardless of how your diversity expresses itself, you can find a home here at iCIMS. We are proud to be an equal opportunity and affirmative action employer. We prohibit discrimination and harassment of any kind based on race, color, religion, national origin, sex (including pregnancy), sexual orientation, gender identity, gender expression, age, veteran status, genetic information, disability, or other applicable legally protected characteristics. If you would like to request an accommodation due to a disability, please contact us at [email protected]. Compensation and Benefits The target total compensation for this role is: $132,000 - $176,000 Your actual compensation will be based upon your experience. iCIMS offers the following benefits: medical, dental, vision, 401(k), an open vacation policy, sick days, short-term disability, long-term disability, maternity/bonding and parental leave, tuition reimbursement, flexible savings accounts, paid holidays, life and AD&D insurance.
Similar Jobs in this Field
ViiV (GSK) US Competitive Intelligence & Market Research Lead
United States
View →
Remote Support Engineer – Night Shift
United Kingdom
View →
Primary Technical Support Engineer
Philippines
View →
Services Partner Deployment Specialist
Philippines
View →
Senior IT Project Manager
Qatar
View →
Senior Manager Quality Assurance
Qatar
View →
IT Project Manager - Consultant
Qatar
View →
D&it Affiliates Advisor
Saudi Arabia
View →
Þmo Site Engineer
United Kingdom
View →
Principal Software Engineer
United States
View →
Job Summary
Category
IT
Country
United States
Employment Type
Full Time
Verified & Trusted Listing
Listing details are verified for a safe and direct job application experience.