Solution Architect/Database Engineer

About the position

This position is hybrid/remote role open to multiple client locations in the United States. A qualified applicant must be local to those areas or be open to relocation. Cognizant's Cloud, Infrastructure, and Security Services Practice (CIS), is all about embracing digital transformation by driving core modernization holistically across layers. We help customers transform infrastructure and workplace to meet the rapidly evolving needs of the digital era. Our holistic approach delivers key results for our customers by achieving cloud driven modernization and workplace and operational transformation to run the business in a secure environment. We are seeking a highly experienced and versatile Solution Architect/Database Engineer with 15+ years of proven expertise in managing and optimizing complex environments. The ideal candidate will possess a deep understanding of Oracle, Databricks, and other database systems, coupled with strong programming and cloud platform skills. This role demands a strategic thinker who can architect robust, scalable, and secure data solutions, ensuring optimal performance and compliance with industry regulations, particularly within the healthcare domain.

Responsibilities

• Design and implement scalable and high-performance database architectures, primarily focusing on Oracle and Databricks.
• Develop and maintain data models, schemas, and database objects.
• Evaluate and select appropriate database technologies to meet business requirements.
• Act as a solution architect, providing expertise on database design and implementation.
• Perform advanced SQL performance tuning and optimization for efficient data retrieval and processing.
• Manage database security, backups, recovery, and disaster recovery procedures.
• Implement and maintain database monitoring and alerting systems.
• Ensure database availability and reliability.
• Design and implement data solutions on Azure, leveraging Databricks, CosmosDB, Function Apps, and other relevant services.
• Demonstrate basic knowledge of AWS and GCP cloud platforms.
• Integrate on-premises databases with cloud-based data warehouses and data lakes.
• Develop and maintain ETL/ELT processes using SQL and Python.
• Utilize R and Cobol as needed for data processing and legacy system integration.
• Implement data quality and data governance best practices.
• Apply machine learning techniques using Scikit-learn, PyTorch, and TensorFlow for data analysis and predictive modeling.
• Create insightful data visualizations using Matplotlib, Seaborn, ggplot, and PowerBI.
• Implement and utilize DevOps practices for database deployment and management.
• Work within an Agile environment, using tools like Jira, Jenkins, GitHub, and Bitbucket.
• Automate database tasks.
• Demonstrate a strong understanding of healthcare data regulations, including HIPAA, PHI, and PII.
• Implement and maintain SOX controls related to database security and access.
• Ensure all database related activity is compliant with all regulatory requirements.

Requirements

• 15+ years of experience in databases includes Oracle, MSSQL, Databricks architecture.
• Expertise in Oracle and Databricks database systems.
• Proficiency in SQL and Python programming.
• Experience with Azure cloud platform, specifically Databricks and Cosmos DB.
• Working knowledge of AWS and GCP.
• Knowledge of machine learning frameworks (Scikit-learn, PyTorch, TensorFlow).
• Experience with data visualization tools (Matplotlib, PowerBI).
• Familiarity with Agile methodologies and DevOps practices (Jira, Jenkins, GitHub, Bitbucket).
• Strong understanding of healthcare data regulations (HIPAA, PHI, PII) and SOX controls.
• Proven experience in SQL performance tuning.
• Excellent problem-solving and communication skills.
• Solution Architect experience.

Nice-to-haves

• Experience with healthcare data warehousing and analytics.
• Experience with Data security best practices.
• Master degree in computer science is preferred.

Benefits

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan