ApTask
Database Engineer
ApTask, Alpharetta, Georgia, United States, 30239
About Client:The client provides information technology (IT) services, including business outsourcing, infrastructure technology, and application services. The application service offered by the company includes application development, maintenance, and support. The markets served by the company are financial services and insurance, healthcare, manufacturing, government, transportation, communications, and consumer and retail industries.
Rate Range: $70-$75/Hr
Job Description:
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 toolsPossess strong database fundamentals and experience in writing Unit test cases and test scenariosTechnical 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: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.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.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.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.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.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.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.
About ApTask:ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Candidate Data Collection Disclaimer:At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
If you have any concerns or queries about your personal information, please feel free to contact our compliance team at businessexcellence@aptask.com
Rate Range: $70-$75/Hr
Job Description:
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 toolsPossess strong database fundamentals and experience in writing Unit test cases and test scenariosTechnical 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: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.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.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.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.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.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.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.
About ApTask:ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Candidate Data Collection Disclaimer:At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
If you have any concerns or queries about your personal information, please feel free to contact our compliance team at businessexcellence@aptask.com