SQL Developer (Remote Opportunity)

View full description

Requirements:

• Bachelor’s degree in Information Technology, Computer Science, Engineering, or an equivalent discipline.
• 5-8+ years of relevant work experience.
• Ability to create logical and functional software code in various languages.
• In-depth knowledge of SQL Server, MySQL, PostgreSQL, or Oracle.
• Expertise in advanced SQL techniques, including stored procedures, triggers, functions, and complex joins.
• Experience with ETL processes, data pipelines, and working with large datasets.

Responsibilities:

• Analyze, maintain, and optimize the database environment to ensure 99.9% availability and data integrity.
• Update database architecture, build schemas, tables, stored procedures, and manage permissions.
• Provide recommendations on policies, procedures, and emerging technologies.
• Monitor systems for availability, oversee database mirroring, replication, and failover.
• Support SQL Server Analysis and SQL Clustered Column Store Index (CCI) technology.
• Generate queries and reports using SQL Management Studio and SQL server tools (SSAS, SSIS, SSRS, SSMA, Sentry Diagnostic Utilities).
• Create, populate, and maintain databases and data cubes for analysis and reporting.
• Restore databases from backups and support disaster recovery activities.
• Communicate effectively with customers, stakeholders, and technical specialists.
• Take on additional tasks and responsibilities as needed to support team objectives and ensure the success of the project.