Database Engineer

Role : Database Engineer

Location : Alpharetta and Marriott, GA Onsite

Duration : Longterm

Description

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 high-performance 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 hands-on experience with a range of database technologies.

Qualifications :

• 4 - 6+ years technical expertise in database and ETL development with Microsoft SQL Server technologies primarily T-SQL 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 cloud-based 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 non-technical arenas.

• Able to understand and convey technical issues to non-technical associates, and vice-versa.
• 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 entity-relationship 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 Transact-SQL (T-SQL) and Microsoft SQL Server Integration Services (SSIS).
• Optimize ETL processes and T-SQL 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 project's business, system and data requirements.
• Create written data migration / conversion plans and data file / data model specifications that meet the project's 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 data-related 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 post-launch 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.
19 days ago