Database Administrator
OVERVIEW:
The Company
Common Securitization Solutions (CSS) is seeking an experienced Database Administrator to join our team of talented professionals. This is a full-time remote opportunity.
CSS built and operates the largest and most advanced mortgage securitization platform in the world, supporting the Uniform Mortgage-Backed Security (UMBS) of Fannie Mae and Freddie Mac.
Supporting 70% of the mortgage-backed securities in the market, CSS provides best-in-class single-family issuance, bond administration, disclosure, and tax services. We support a broad portfolio of products for our clients with full lifecycle management.
Our market-leading, cloud-based, end-to-end platform executes transactions on an extraordinary scale which has bolstered liquidity in the secondary mortgage market, one of the largest and most important financial markets in the world. Our unique approach to securitization combines the best minds in financial services with the know-how, flexibility, and innovation of leading technologists.
RESPONSIBILITIES :
Job Information
Do you have an interest in Cloud Infrastructure support and cloud computing with a focus on multi-RDBMS administration as a part of a highly skilled DBA team? This team is responsible for installation, configuration, and day-to-day support of SQL Server and Oracle on EC2, and a small number of AWS RDS instances.This mid-level DBA position will be working with the Cloud operations team, application support team, SRE team, and business teams. The candidate will need to be able to handle multiple tasks in a fast-paced team environment, participate in on-call rotation to support production infrastructure and be a part of monthly deployment and maintenance activities.
Key Job Functions- Participate in day-to-day DBA operations performing tasks such as working on change tickets that involve executing SQL scripts in Production, resolving incident tickets related to database availability, backups, free disk space, long-running queries, etc.
- Participated in on-call rotation, attending to database related alerts and notifications in a timely manner and taking appropriate action to resolve the underlying issue(s).
- In addition to performing the daily DBA tasks, contribute towards the success of the on-going projects related to automation, infrastructure-as-a-code, technology updates, containerization, etc.
- Assist development and QA teams with deployment activities by performing DBA tasks assigned in the runbook.
- Actively support operational teams and other stakeholder teams to provide business systems availability and maintain customer satisfaction.
- Support the production and lower environments infrastructure 24/7 as part of the production support team.
- Participate in on-call rotation as infrastructure support primary to support production.
QUALIFICATIONS:
Education- Bachelor’s degree in Computer Science, MIS or related technical field required.
- Minimum 4 years related work experience managing SQL Server 2016 or newer, Amazon RDS and Oracle 19c databases in AWS production environments.
- Applicants must be authorized to work in the US without requiring employer sponsorship currently or in the future. CSS does not offer H-1B sponsorship for this position.
- Proven experience in managing SQL Server 2016 or higher, Amazon RDS and Oracle 19c as a DBA, preferably including Production environment.
- Clear understanding of backup and recovery procedures for Oracle 19c using RMAN and SQL Server native backups.
- Understanding of basic database concepts, such as indexes and statistics, concurrency and blocking, transactions, data caching.
- Experience with database performance and tuning is highly desirable.
- Solid understanding of SQL Server tools such as SQL Server Management Studio, SQL Server Agent, SQL Server Configuration Manager.
- Experience with HA/DR strategies for SQL Server, including Always-On Availability Group.
- Experience with Oracle Grid Infrastructure (including ASM) and Oracle Data Guard is highly desirable.
- Knowledge of Linux and Windows operating systems and experience in supporting database servers on both.
- A working knowledge of AWS Cloud Infrastructure, including but not limited to Regions and AZs, EC2, EBS, NACL & Security Groups, CloudWatch, Event Bridge, etc.
- Experience in scripting/deployment languages such as PowerShell, Python is a plus.
- Strong verbal and written communication skills with the ability to collaborate well across functional teams.
- Ability to troubleshoot system issues, problems, identifying root causes and fixing them.
- Fair knowledge of computer hardware, software, and networking concepts and terminologies.
- Basic understanding of CI/CD methodologies.
- Professional Certifications in AWS, Azure and Database technologies is a plus.
- Must be willing to provide on call support on a rotation basis for 24x7 support. When on call, requires off hour and weekend support.
Pay Range $81,000 to $94,250
CSS’s pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) a candidate’s qualifications, skills, competencies, and experience, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.CSS offers a competitive total compensation package, which includes a performance bonus, 401k match, healthcare coverage, PTO, and a broad range of other benefits.
Employment
As a condition of employment with Common Securitization Solutions, any successful job applicant will be required to successfully complete a background investigation, which may also include a credit check for positions in some areas of our business.
Common Securitization Solutions is an Equal Opportunity Employer.
##LI-Remote