SQL developer

ADP WFN Test Company 1; California (MO); On-site; USD 120,000 - 180,000; Full time

Job summary

ADP WFN Test Company 1 is seeking a database professional to design, develop, and optimize relational databases. You will ensure data integrity and security while supporting applications with robust data storage and efficient queries.

The role involves collaborating with developers and analysts to deliver reports, dashboards, and data-driven insights, plus managing backups and staying current with the latest database technologies.

Qualifications

• Relational database design experience
• Strong SQL and query optimization skills
• Knowledge of data security, access controls, and backups

Responsibilities

• Database design and development: create and maintain schemas, tables, views, stored procedures, and other objects
• SQL query optimization: write and optimize complex queries for performance
• Data management: implement storage solutions, ensure data integrity and security
• Troubleshooting and debugging: identify and resolve database issues, performance bottlenecks, and data inconsistencies
• Collaboration: work with front-end developers, analysts, and stakeholders to integrate databases with applications
• Reporting and analysis: develop and maintain reports and dashboards
• Database administration: manage backups, restores, and other admin tasks
• Staying up-to-date: keep current with database technologies and best practices

Job description

Responsibilities

• Database Design and Development: Creating and maintaining database schemas, tables, views, stored procedures, and other database objects.
• SQL Query Optimization: Writing and optimizing complex SQL queries for performance and efficiency.
• Data Management: Implementing data storage solutions, ensuring data integrity, and managing data access and security.
• Troubleshooting and Debugging: Identifying and resolving database-related issues, including performance bottlenecks and data inconsistencies.
• Collaboration: Working with front-end developers, analysts, and other stakeholders to integrate database solutions with applications and business processes.
• Reporting and Analysis: Developing and maintaining reports, dashboards, and other data analysis tools.
• Database Administration: Managing database backups, restores, and other administrative tasks.
• Staying Up-to-Date: