Data Administrator
Job Description
Lexis Nexis Legal and Professional operates a large platform for applications and services to legal professional across the globe. As part of the SRE and Cloud Operations team, this role helps support all of the critical relational and nonrelational systems that power our advanced search and retrieval systems.Our systems are primarily hosted in the AWS cloud and we manage and maintain a large set of databases technologies to support our business. Lexis Nexis is on the leading edge of technology adoption and are leading the market with the adoption of AI systems driver by LLM technologies.
As a DBA you will use to AWS database management skills to help optimize the creation, deployment and operation of databases technologies across production and non-production systems globally. This position requires solid relational database development skills in addition to specific experience with AWS RDS databases.
This role offers tremendous opportunities for growth, and we encourage our technologists to explore opportunities outside of their core responsibilities and we provide lots opportunities to work with new technologies. This role supports critical customer applications that must be operational 24x7 with a 99.99% uptime goal. If you have a passion for cloud technologies and want to explore opportunities in the most cutting-edge technology spaces, this is the role for you.
Responsibilities:
As a key member of the SRE and Cloud Operations team, you will use your database and AWS experience in the following areas:
Automate the creation of standard database configurations for a wide variety of platforms including Oracle, Postgres, MySQL, SQL Server
Maintain, support and upgrade database systems as required
Work with AWS to coordinate mandatory version upgrades
Assist development teams with migrations between database platforms e.g. moving Oracle databases to Postgres
Troubleshoot performance issues and assist development teams with query optimizations
Participate in 24x7 on-call support rotation
Manage all capacity decisions for production deployments including technology selection, high availability configuration, storage and compute needs, etc.
Assimilate knowledge in support of non-relational databases like DocumentDB, Dynamo, Apache Solr, Cassandra, Redis etc.
Requirements
Bachelor's degree (Information Systems, Computer Science/Engineering)- 6 years of overall DBA experience with at least 1 year of hands on experience using AWS RDS systems
Work experience with multiple database platforms; our most critical systems run in Oracle and Postgres but SQL Server and MySQL are also used
Experience with automation and IaC tools like CloudFormation and Terraform is desirable
Scripting capability (Python, BASH, JavaScript, Go etc.)
Demonstrated experience solving performance and capacity problems AWS certifications are desirable but not a requirement; we will give you the resources required to study and achieve critical certifications as part of your role
Spotlight- Retirement benefits, Health & insurance