Database Engineer

Position Overview: The Database Engineer for Digital Project Implementation plays a crucial role in the success of digital projects by managing the databases that underpin them. This role involves designing robust scalable and highperformance database solutions integrating them with various digital platforms and ensuring data integrity and security throughout the project lifecycle. The ideal candidate will have a strong background in database architecture data modeling and handson experience with a range of database technologies.

Qualifications:

• 4 6 years technical expertise in database and ETL development with Microsoft SQL Server technologies primarily TSQL and SSIS.
• Extensive development experience in analysis modelling and design of database solutions.
• Integration Services ETL and BI tools
• Possess strong database fundamentals and experience in writing Unit test cases and test scenarios
• Technical understanding of network PC and platform operating systems including Microsoft Windows Server 2008 through current version.
• Application development understanding of Microsoft .NET technologies primarily Powershell scripting ASP.NET and C#.
• Technical understanding of the different phases of the Software Development Life Cycle (SDLC) including waterfall and agile methodologies.
• Understanding and technical knowledge of cloudbased technologies.
• Have a grasp of SQL Server High Availability Solutions including Always On Database Mirroring and Log Shipping concepts.
• Able to effectively communicate verbally and in writing; in large meeting settings and when presenting to large groups; in both technical and nontechnical arenas.
• Able to understand and convey technical issues to nontechnical associates and viceversa.
• Able to develop and maintain effective working relationships across enterprise level lines.
• Able to identify issues warranting escalation.

Key Responsibilities:

1. Database Design & Architecture:

• Design and implement database solutions to support digital project requirements.
• Create data models schemas and entityrelationship diagrams to represent data structures.
• Ensure database designs meet performance scalability and security requirements.

2. Database Development & Optimization:

• Perform extensive analysis of database entities relationships and attributes.
• Design and develop ETL (Extract Transform and Load) processes using TransactSQL (TSQL) and Microsoft SQL Server Integration Services (SSIS).
• Optimize ETL processes and TSQL code performance using Microsoft SQL Server best practices and query/index/table performance tuning.
• Participate in both data design and data processing sessions for assigned projects and teams.
• Create migration/conversion designs that meet the projects business system and data requirements.
• Create written data migration/conversion plans and data file/data model specifications that meet the projects business system and data requirements.
• Reverse engineer existing migration/conversion processes and data models including designing and utilizing Microsoft SQL Server Profiler traces.
• Research and review data for presentation accuracy and compliance within the business/system needs.
• Review with team members/client and other database engineers the content accuracy and completeness of data models file specifications and migration/conversion processes.
• Communicate and collaborate with client management and client data specialists in the design and delivery of data migration/conversion processes.
• Respond to data design and/or data processing problems and find solutions in a timely manner.
• Identify appropriate resources and work with them to research and resolve any open datarelated issues.
• Mentor staff by reviewing deliverables and offering team assistance whenever needed.
• Possesses a deep knowledge of both the product and the technology; use both to design/architect business solutions.

3. Data Integration & Migration:

• Support data integration between different systems and platforms involved in digital projects.
• Plan and execute data migrations ensuring data integrity and minimal downtime.
• Collaborate with software engineers to integrate databases with applications.

4. Security & Compliance:

• Support in database security measures including access controls encryption and auditing.
• Ensure compliance with data protection regulations and company policies.
• Conduct regular security assessments and address vulnerabilities promptly.

5. Database Administration & Maintenance:

• Perform routine database maintenance tasks such as backups restores and updates.
• Monitor database health including disk usage memory and CPU utilization.
• Automate repetitive tasks and develop scripts for database management.

6. Collaboration & Support:

• Work closely with project managers software engineers and other stakeholders to understand database requirements and constraints.
• Provide technical support and guidance during project implementation and postlaunch phases.
• Participate in code reviews design discussions and project planning sessions.

7. Documentation & Reporting:

• Maintain comprehensive documentation for database designs configurations and processes.
• Prepare reports on database performance capacity planning and future growth projections.
• Document best practices and lessons learned from each project.