Database Engineer - ApTask

About Client:
The client is a leading digital transformation consultancy and engineering services company that specializes in driving digital transformation for Fortune 1000 enterprises. The company provides a comprehensive range of services, including cloud migration, big data analytics, machine learning, artificial intelligence, and DevOps. It is known for its deep technical expertise and innovative solutions that help businesses optimize operations, improve customer experience, and accelerate time-to-market. The company operates globally, with development centers and offices across the United States, Europe, and Latin America.



Rate Range: $60-$65/Hr



Job Description:

• We are looking for a Staff Database Engineer to join our team and work on designing, modeling and optimizing OLTP related database technologies (RDMBS and NoSQL); and dive deeper with Application Architects and DBAs to build applications (with tens of millions of active accounts transacting with more than 1000+ tps).
• Additionally, you’ll be working on Data Warehouse solutions (leveraging AWS Redshift, Databricks and others) to build the performant data movement pipelines across OLTP and OLAP and give complete End-to-End coverage of data lifecycle.
• However, your primary responsibility will remain OLTP focused RDBMS and NoSQL database solutions.

• Design and development of various data models associated with Relational DBs (MS SQL Server, PostgreSQL, or similar) and NoSQL DBs (Cassandra, Cosmos DB, Dynamo DB or similar)
• Ensuring database features and capabilities are incorporated into data model designs to optimize performance, resiliency, and scalability (with tens of millions of active accounts transacting with more than 1000+ tps)
• Working closely with other technology leaders to design and develop enterprise-wide data strategy for data modeling, data pipelines, and data integrations across various environments and technology stacks
• Developing performant data movement pipelines using real-time event data streams (Apache Kafka, Azure Event Hub, AWS Kinesis, Azure Databricks etc.)
• Designing and implementing performant cloud data warehouse platforms (Redshift, Azure Databricks, SQL DW, Snowflake, or similar)
• Delivering and presenting proofs of concept to of key technology components to project stakeholders and internal technology leaders
• Developing the data architecture and governance models for systems of engagement and provides the framework for integrating source systems with the transactional databases and/or data warehouses; Ensuring data architectural designs are consistent, maintainable, flexible, extensible and cost effective
• Ensuring data security and privacy standards are implemented including- role based security, encryption, tokenization, and obfuscation
• Performing problem-solving of application issues and production errors, including high level critical production issues that require immediate attention
• Work with other technology leaders on setting database standards and best practices for designing and architecting cloud-based data and reporting applications

• Minimum 8 years of overall software development experience
• Minimum 6 years of hands-on experience in database engineering (RDMBS and NoSQL)
• Bachelor’s degree in Computer science, Computer Engineering or related field
• Experience with RDMBS (primarily MS SQL Server); proficiency with advanced SQL concepts (T-SQL, PL/SQL, etc.) that processes millions of transactions daily with very high processing rates to support mission critical databases
• Good understanding of SQL engine internals to help design and tune databases to get the optimal performance
• Development experience with NoSQL DBs (Cassandra, Cosmos DB, Dynamo DB or similar); and associated data modeling
• Experience in designing, developing, and deploying cloud-based solutions which leverage cloud provided platforms (Azure / AWS)
• Development experience with cloud-based data warehouse platform (Azure Databricks, Azure Synapse, AWS Redshift, Snowflake, etc.)
• Knowledge of data structures and algorithms and excellent programming skills (.NET, C#, Python and/or Java)
• Demonstrated expertise in performance tuning in various DB environments with large volume and velocity of data
• Experience working in a Dev/Ops environment with tools such as Azure Dev Ops, Microsoft Visual Studio Team Services, Chef, Puppet or Terraform
• Experience in handling structured and semi structured data forms like JSON/XML and normalization of data structures
• Understanding of OLTP and OLAP applications

• Azure cloud certification is desirable.

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 .

Applicant Consent:
By submitting your application, you agree to ApTask's (www.aptask.com) Terms of Use and Privacy Policy , and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at 732-355-8000 or help@aptask.com. Message frequency may vary. Msg & data rates may apply.