What are the responsibilities and job description for the Database Engineer position at TechnoGen?
Role : Database Engineer
Location : Alpharetta and Marriott, GA (Onsite from day 1)
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.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Database Engineer?
Sign up to receive alerts about other jobs on the Database Engineer career path by checking the boxes next to the positions that interest you.
