Database Administrator
Share
Job Location:
Monthly Salary:
Posted on:
7 hours ago
Vacancies:
1 Vacancy
Job Summary
The role involves working with project teams to implement and support reliable high-performance relational database management systems for Experians core business applications. You will ensure the implementation and support of database components in accordance with established policies and procedures. This includes working with project teams to define database schemas maintenance plans performance metrics and growth forecasting.
You will also define measure and analyse key metrics to assess database availability and ensure that Service Level Agreements are achieved. Scheduling production changes to databases including data updates and SQL Server configuration will be part of your responsibilities. Additionally you may be required to oversee client satisfaction and manage the resolution of database related issues.
Key Responsibilities
- Installing and configuring new database systems.
- Designing and implementing new database schemas and objects.
- Modification to existing database objects in line with team defined standards.
- Data migration between different database products.
- Work as part of project teams to assist developers with optimisation and standardisation of code.
- Working with the security team to audit database security on a regular basis.
- If necessary manage the ticket queue and communicate with relevant stakeholders.
- Provisioning of database access in line with defined security measures including installation and testing of new databases.
- Documentation including catalogue of SQL server real estate database jobs and data dictionaries.
- Monitoring mailboxes monitoring tools and alerts queues.
- Assist with patches and upgrades
Qualifications :
- Bachelors degree or equivalent years of experience.
- At least two years of experience with large databases.
- At least two years of experience with databases in high-availability configuration.
- Proven industry experience developing in both AWS and Azure.
- Strong experience / skills administering Microsoft SQL Server 2012 and above.
- Amazon RDS (SQL Server MySQL).
- Demonstrable experience with T-SQL SSIS DTS.
- Demonstrable experience with SSRS (SQL Server Reporting Services).
- Experience in Azure SQL MI Data Factories monitoring and administration using native tools.
- AWS Glue DMS (Database Migration Service) and Lambda for lightweight ETL.
- CloudFormation Terraform or CDK.
- Version-controlled DB infrastructure and automated provisioning pipelines.
- Proven experience with Clustering Database Mirroring Log shipping and Replication.
- Familiarity with both Azure Native and AWS Backup services.
- AWS IAM roles & policies and database authentication methods (IAM DB Auth password rotation Secrets Manager).
- Exposure to monitoring tools such as Diagnostic Manager System Centre Operations Manager Amazon CloudWatch metrics (CPU IOPS connections deadlocks) Performance Insights (query performance waits) etc.
- Experience executing Disaster Recovery plans.
Preferred Qualifications
- Amazon RDS (PostgreSQL Oracle).
- Amazon Redshift Redshift COPY/UNLOAD techniques etc.
- Basic Networking knowledge i.e.
- VPCs subnets routing
- Private endpoints
- Peering and VPC security
- DNS (RDS endpoints cluster endpoints)
- Python or PowerShell for automation.
- Understanding of and exposure and XML technology.
Behavioral Competencies
- Proven ability in organisation communication and writing skills.
- Great collaborator that works well cross-functionally.
- Can-do and positive attitude under pressure.
Additional Information :
Our uniqueness is that we truly celebrate yours. Experians culture and people are key differentiators. We take our people agenda very seriously and focus on what truly matters; DEI work/life balance development authenticity engagement collaboration wellness reward & recognition volunteering... the list goes on. Experians strong people first approach is award winning; Great Place To Work in 24 countries FORTUNE Best Companies to work and Glassdoor Best Places to Work (globally 4.4 Stars) to name a few. Check out Experian Life on social or our Careers Site to understand why.
Experian is proud to be an Equal Opportunity and Affirmative Action employer. Innovation is a critical part of Experians DNA and practices and our diverse workforce drives our success. Everyone can succeed at Experian and bring their whole self to work irrespective of their gender ethnicity religion colour sexuality physical ability or age. If you have a disability or special need that requires accommodation please let us know at the earliest opportunity.
#LI-Hybrid
This is a hybrid remote/in-office role.
Experian Careers - Creating a better tomorrow together
Find out what its like to work for Experian by clicking here
Remote Work :
No
Employment Type :
Full-time
Key Skills
- Databases
- Disaster Recovery
- SQL
- High Availability
- Microsoft SQL Server
- ssrs
- Database Design
- Performance Tuning
- SSIS
- Database Administration
- Sybase
- Oracle
About Company
Experian is a global data and technology company, powering opportunities for people and businesses around the world. We help to redefine lending practices, uncover and prevent fraud, simplify healthcare, create marketing solutions, and gain deeper insights into the automotive market, ... View more
