Lead Database Administrator - Tech/ Infra

Company: Kroll Bond Rating Agency, LLC
Location: New York
Posted on: June 25, 2022

Job Description:

Position Title: Lead Database Administrator Department: Technology Employment Type: Full-time Location: NY or PA or Remote Overview We're seeking a Lead Database Administrator to join our Infrastructure Team. The DBA team is focused on supporting internal engineering and analytical teams by creating systems & services and providing guidance to help them reach their operational goals. The organization is transforming to a model where small, empowered teams own the things they build from inception through production. The DBA team in addition to supporting and maintaining legacy infrastructure, will also work to provide resources to these teams to enable them to build & deploy scalable, observable, reliable, and secure applications. We value learning and make time during the workday for our team members to grow their skillsets. About the Job The role encompasses a wide range of responsibilities and will have an impact across the organization. It will require building relationships with engineers as well as business users and all changes will have to be made while considering their impact on multiple products with active users. This is a unique opportunity for someone who is looking to grow into a more strategic role while supporting and building KBRA's database environment; someone who is not happy with the status quo and always looking for ways to use emerging technologies to solve business problems. We are looking for someone who is highly motivated and a self-starter; someone who loves new challenges and likes working in agile environment. Responsibilities Help to define and share the vision for our internal data platforms and services. Research and implement solutions that address cross-cutting concerns. Create and operate systems using pipelines for deployments and evolve legacy systems to that model as well. Participate in Blameless Postmortems of production issues in order to identify potential improvements. Advocate for scalable, observable, reliable, and secure practices across the organization. Iterate over solutions and deliver work incrementally rather than delivering large, risky chunks of work. Mentor and frequently collaborate with people inside and outside the team. Be on-call for services that the DBA team owns and be available during production issues of systems use our systems. Oversee all database operations including planning, configuration, troubleshooting, monitoring, security configurations and migrations Build & manage databases in multiple environments, from development to mission-critical production systems. Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers. Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets. Help engineering team members write efficient queries Research & collaborate with engineering teams to implement the best data solution for the application/service being built. Skills & Experience: SQL Server 2016/17 administration experience required Experience with Performance Tuning and Optimization (PTO), using native and 3rd party monitoring and troubleshooting tools Experience with backups, restores and recovery models Demonstrated understanding of complex SQL, stored procedures, database functions, SSIS and ANSI and T-SQL queries and scripts. Knowledge of High Availability (HA), Always On Availability Groups, MS SQL Clustering and Disaster Recovery (DR) options for SQL Server Demonstrated knowledge of Data Security and data protection best practices Experience with implementing and migrating to NoSQL technologies Experience with implementing and migrating to MySQL Writing CI/CD pipelinesAzure DevOps and/or GitLab preferred Linux Operating System experience (nice to have) Managing database environments regardless of its location, on-prem/cloud Project management experience Experience working with container-based applications leveraging Docker swarm/Kubernetes Building & maintaining systems using Infrastructure as Code Experience with Python & PowerShell Experience with MariaDB, MongoDB, Snowflake, Aerospike, Postgres etc (nice to have) Exposure to Azure SQL & AWS RDS and other cloud/SaaS technologies in production KBRA Benefits A hybrid work schedule and flex hours will be in place when we formally return to the office Competitive benefits and paid time off Paid family and disability leave 401(k) plan, including employer match (100% vested) Educational and professional development financial assistance Employee referral bonus program Cell phone reimbursement More Info All KBRA employees must be fully vaccinated against Covid-19 as a condition of employment with KBRA and must provide sufficient written documentation to KBRA of such vaccination, unless the employee is unable to be vaccinated against Covid-19 because of a sincerely-held religious belief or a documented medical condition.KBRA encourages applications from all qualified individuals without regard to race, color, religion, gender, sexual orientation, gender identity or expression, age, national origin, marital status, citizenship, disability, and veteran status or any other basis prohibited by federal, state or local law. About Us KBRA is a global full-service rating agency whose mission is to set a standard of excellence and integrity by providing users of our ratings with transparent, responsive, and timely analysis. Established in 2010 as a challenger brand, KBRA remains dedicated to the restoration of trust in credit ratings. We accomplish this through the creation of new standards for assessing risk and by offering transparent ratings. KBRA offers market participants with an alternative solution by delivering in-depth research as well as the tools needed to make informed decisions. Since the company was founded, we have published over 50,000 ratings. KBRA has over 430 employees located across the United States (in New York, Pennsylvania and Maryland) and in Dublin, Ireland and London, England.

Keywords: Kroll Bond Rating Agency, LLC, New York , Lead Database Administrator - Tech/ Infra, IT / Software / Systems , New York, New York