Legal Staff Information Technology in Houston, TX

Law Firm

Houston, TX

Legal Staff Information Technology in Houston, TX

Legal Staff

Min 7 yrs required

No

Job Title: Senior Database Developer

Job Responsibilities:
- Architect and develop scalable database solutions using MS Fabric and SQL Server.
- Develop, implement, and optimize ETL packages, stored procedures, triggers, views, and functions using T-SQL.
- Analyze existing SQL queries, explain plans, and suggest improvements.
- Develop procedures and scripts for data migration.
- Create and optimize data models.
- Lead cloud database migration projects, ensuring minimal downtime and data loss.
- Integrate various data sources to create unified data models.
- Analyze and optimize database performance, ensuring efficient query execution and resource utilization.
- Implement database changes deployment automation using Azure DevOps (ADO) pipeline.
- Implement security measures to protect sensitive data and ensure compliance with industry standards.
- Maintain comprehensive documentation of database designs, configurations, and migration processes.
- Work closely with cross-functional teams to understand business requirements and deliver tailored database solutions.
- Mentor junior database developers and conduct training sessions to enhance team skills.
- Stay updated with the latest database technologies and trends and implement innovative solutions.

Education and Experience Information:
- Bachelor's degree in computer science, information technology, or a related field.
- Minimum of 7 years of experience in database development, with a focus on MS Fabric, SQL Server, and cloud migration.
- Expertise in MS Fabric and its applications in database development.
- Proficient in SQL Server, including T-SQL programming, stored procedures, and triggers.
- Experience with cloud database platforms.
- Experience with following SDLC and Agile processes.
- Experience with assisting business in creating functional specifications.
- Experience with creating technical specifications documents based on functional specifications.
- Experience with database mirroring (., CDC etc.).
- Strong understanding of database architecture and design principles.
- Experience with ETL/ELT design, creation, and tools.
- Familiarity with data warehousing and BI solutions.

Soft Skills:
- Excellent problem-solving and analytical skills.
- Strong communication and interpersonal abilities.
- Ability to work independently and as part of a team.
- Sense of ownership and pride in your performance and its impact on the company’s success.
- Detail-oriented with a focus on quality and accuracy.
- Proactive and self-motivated with a drive for continuous improvement.
- Certifications: Relevant certifications in MS Fabric, SQL Server, and cloud platforms are preferred.

Salary Information:
The text does not provide specific salary information. However, it mentions that the law firm is committed to providing a comprehensive and competitive benefits package, which includes access to three medical plans, dental, vision, life, and disability insurance. Employees can also access pre-tax benefits such as health savings and flexible spending accounts. The law firm provides financial security by allowing employees to participate in a 401(k) savings plan and profit-sharing plans if eligible. Full-time employees are eligible to access fertility benefits designed to support fertility and family-forming journeys. Additionally, the law firm offers a competitive paid time off plan, a generous paid parental leave benefit, and employees are entitled to 11 firm holidays.