Database Engineer - Dallas, TX

We are seeking a highly skilled and experienced Database Engineer to join our growing team. You will be responsible for designing, developing, and maintaining our critical databases, ensuring high performance, reliability, and security. This role will involve collaborating with various teams, including development, security, and operations, to deliver data solutions that meet the evolving needs of our business.

Responsibilities:

Database Design & Development:

Collaborate with stakeholders to understand data requirements and design efficient database schemas.

Create comprehensive database documentation, including ER diagrams, data models, and data dictionary.

Develop and execute DDL scripts for creating, altering, and maintaining database objects.

Data Management & Automation:

Manage database deployments and upgrades using tools like Datical.

Implement and maintain data migration strategies and processes.

Develop and maintain data quality control procedures.

Automate database tasks using scripting languages (e.g., Python, Shell).

Performance Optimization & Tuning:

Analyze database performance metrics, identify bottlenecks, and implement solutions for optimization.

Optimize queries and indexes for improved performance and reduced query execution times.

Implement database caching strategies to enhance performance.

Security & Compliance:

Ensure compliance with security policies and regulations.

Implement security measures such as user access controls, data encryption, and auditing.

Monitor database security logs and investigate suspicious activity.

Cloud Database Management:

Manage and maintain database instances on AWS EC2 and RDS.

Implement and optimize database deployments in a cloud environment.

Understand and leverage AWS database services (e.g., DynamoDB, Redshift).

Oracle Expertise:

Implement and manage Oracle Virtual Private Database (VPD) for data access control.

Utilize Oracle Real Application Security (RAS) for database security and auditing.

Snowflake Expertise:

Design and implement secure views in Snowflake for data access control.

Configure and manage row-level access policies in Snowflake.

Optimize Snowflake queries and storage for cost-efficiency and performance.

Collaboration & Communication:

Collaborate effectively with developers, data analysts, and other stakeholders.

Communicate technical concepts clearly and concisely to both technical and non-technical audiences.

Actively participate in team meetings and code reviews.

Qualifications:

Bachelor's degree in Computer Science, Information Systems, or related field.

5+ years of experience as a Database Engineer or equivalent role.

Strong understanding of relational database concepts and principles.

Proven experience with database design and development using SQL.

Hands-on experience with data modeling tools (e.g., ERwin, Visio).

Expertise in database performance optimization techniques and tools.

Experience with database automation tools (e.g., Datical, Liquibase).

Proficiency in scripting languages (e.g., Python, Shell) for database administration.

Experience with AWS EC2 and RDS services.

Deep understanding of Oracle VPD and RAS features.

Experience with Snowflake secure views and row access policies.

Strong analytical and problem-solving skills.

Excellent communication and interpersonal skills.

#J-18808-Ljbffr