Mid-Level Database Architect

Jobright.ai is an AI-powered career platform that helps you discover verified jobs directly from employer sites across the U.S. and tailor your applications with ease. Please note: Jobright is not a staffing agency and does not hire for these roles directly.

Job Summary:

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world. They are seeking a skilled and strategic Database Architect to design, develop, and optimize robust, scalable, and secure database systems to support the organization's data needs.

Responsibilities:

• Design and develop database architectures, including relational, NoSQL, and hybrid systems, to support business applications and data processing needs.

• Create and document data models, schemas, and database structures to ensure scalability, performance, and maintainability.

• Collaborate with developers, data engineers, and business stakeholders to understand requirements and translate them into effective database designs.

• Optimize database performance through indexing, partitioning, query optimization, and other tuning techniques.

• Ensure data integrity, security, and compliance with standards (e.g., GDPR, HIPAA, PCI-DSS) through proper design and access controls.

• Evaluate and select database technologies (e.g., MySQL, PostgreSQL, MongoDB, Oracle, SQL Server) based on project needs and organizational goals.

• Design and implement data migration, backup, and disaster recovery strategies to ensure data availability and resilience.

• Monitor database performance, identify bottlenecks, and implement solutions to improve efficiency and reliability.

• Lead the integration of databases with applications, cloud platforms, and data warehouses or lakes.

• Provide technical leadership and mentorship to database administrators, developers, and other IT staff on best practices and standards.

• Stay current with emerging database technologies, trends, and best practices to drive innovation and continuous improvement.

• Create and maintain detailed documentation, including data models, architecture diagrams, and operational procedures.

Qualifications:

Required:

• Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field

• 7 years of experience in database design, administration, or development, with at least 3 years in a database architecture role

• Proven experience designing and managing large-scale, high-performance database systems

• Expertise in relational database management systems (e.g., MySQL, PostgreSQL, Oracle, SQL Server) and NoSQL databases (e.g., MongoDB, Cassandra, DynamoDB)

• Strong knowledge of data modeling, schema design, and normalization/denormalization techniques

• Proficiency in SQL and query optimization for performance and scalability

• Experience with cloud database solutions (e.g., AWS RDS, Azure SQL, Google Cloud Spanner)

• Familiarity with data warehousing, ETL processes, and big data technologies (e.g., Hadoop, Spark, Snowflake)

• Understanding of database security, encryption, and compliance requirements

• Experience with backup, recovery, and high-availability strategies for databases

• Knowledge of scripting or programming for automation (e.g., Python, Bash, PowerShell)

• Strong analytical and problem-solving skills to address complex data challenges

Preferred:

• Master's degree

• Certifications such as Oracle Certified Professional, Microsoft Certified: Azure Database Administrator, or AWS Certified Database - Specialty

• Experience with data lake architectures and big data frameworks

• Background in designing databases for specific industries (e.g., finance, healthcare, e-commerce)

• Familiarity with DevOps practices and tools for database automation and CI/CD integration

Company:

Capgemini is a software company that provides consulting, technology, and digital transformation services. Founded in 1967, the company is headquartered in Paris, Ile-de-France, FRA, with a team of 10001 employees. The company is currently Public Company. Capgemini has a track record of offering H1B sponsorships.