-
Design, build, and maintain efficient, reusable, and reliable database objects (queries, stored procedures, triggers, functions, views).
-
Generate and update Database model(s) and diagrams.
-
Determine and communicate the implications of system-level decisions on subsystems and components, and help determine how best to mitigate or take advantage of these implications.
-
Maintain data dictionary.
-
Work with Data Science and Product engineering teams and address database requirements.
-
Extract, analyze, transform & load client data in different formats/sources to database.
-
Perform unit and system level testing on database objects.
-
Help maintain code quality and organization.
-
Ensures database performance, integrity, security, availability and compatibility with existing features.
-
Design automation scripts to provide end-user support and regular maintenance to the databases.
-
Ensure all database servers backups in a way that meets the business’s Recovery Point Objectives (RPO).
-
Test backups to ensure we can meet the business’s Recovery Time Objectives (RTO).
-
Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
-
Install and configure new SQL Servers instances, patches and hot fixes.
-
Plan and execute SQL server implementations, server-to-server migrations.
-
Document database environment changes and process implementations.
-
Create maintenance plans and monitor maintenance jobs.
The successful candidates must have a degree of Computer Science or related field.
-
Excellent SQL skills for complex data analysis and data quality assurance.
-
Hands-on experience with table spaces, indexes, partitions, and query performance tuning.
-
Knowledge to mapping multiple data sources from various data formats and normalizing the data into SQL repositories.
-
Create and maintain conceptual, logical, and physical database models.
-
Strong analytical and problem-solving capabilities.
-
1-3 years of SQL Developer experience; 1-2 year(s) of SQL DBA experience.
Position available in our Atlanta, Georgia office. If interested, email resumes and job history to [email protected]. We will not consider contractors and remote applicants. Absolutely no recruitment agency please.
