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.