SQL Programmer

This is a remote position.

Schedule:

• Full-time
  
• 40 hours per week or 8 hours per day
  
• Monday - Friday
  
• 8:00 AM - 5:00 PM EST 
  
• With 1 hour unpaid lunch break 
  

Client location or time zone: United States - EST

Company/client overview: The client is a law firm located in Tampa Florida, USA. Client offer services like record keeping, planning, legal advice, medical appeals, power of Attorney and many more.

Key Responsibilities:

• Database Development: Design, develop, and maintain SQL databases, tables, views, stored procedures, functions, and triggers.
  
• Query Optimization: Write and optimize complex SQL queries for performance, scalability, and efficiency.
  
• Data Management: Ensure data integrity, consistency, and security across multiple database environments.
  
• ETL & Data Integration: Develop and maintain ETL (Extract, Transform, Load) pipelines using SSIS, Talend, or other tools.
  
• Database Administration Support: Assist in indexing, partitioning, backup strategies, and performance tuning.
  
• Automation & Scripting: Automate database tasks using SQL scripts, batch processing, or Python.
  
• Collaboration: Work closely with developers, data analysts, and business intelligence teams to support application and reporting needs.
  
• Troubleshooting & Maintenance: Monitor database health, troubleshoot performance issues, and ensure high availability.
  

Requirements

​
Required Skills & Qualifications:

• Education: Bachelor's in Computer Science, Information Systems, or related field.
  
• SQL Expertise: Proficiency in T-SQL, PL/SQL, MySQL, PostgreSQL, or other relational databases.
  
• Database Systems: Experience with Microsoft SQL Server, Oracle, MySQL, or PostgreSQL.
  
• Query Optimization: Strong knowledge of indexes, execution plans, stored procedures, and query performance tuning.
  
• ETL & Data Warehousing: Experience with ETL tools (SSIS, Talend, Informatica) and data warehousing concepts.
  
• Scripting & Automation: Familiarity with Python, PowerShell, or Shell scripting for database automation.
  
• Security & Compliance: Understanding of data security, role-based access, and database encryption.
  
• Soft Skills: Strong analytical, problem-solving, and communication skills.
  

Preferred Qualifications:

• Experience with cloud-based databases (AWS RDS, Azure SQL, Google BigQuery).
  
• Knowledge of NoSQL databases (MongoDB, Cassandra) and data lakes.
  
• Experience with CI/CD for database deployments.
  
• Familiarity with data visualization and reporting tools (Power BI, Tableau, Looker).