SQL Developer
LOCATION: ATLANTA, GEORGIA
Position Duties
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.
Requirements
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 jobs@prorize.com. We will not consider contractors and remote applicants. Absolutely no recruitment agency please.