This is a remote position.
Schedule:
- Fulltime
- 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: Bachelors in Computer Science Information Systems or related field.
- SQL Expertise: Proficiency in TSQL 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 rolebased access and database encryption.
- Soft Skills: Strong analytical problemsolving and communication skills.
Preferred Qualifications:
- Experience with cloudbased 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).
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).