Citizant

Database Architect, SME

Citizant

full-time

Posted on:

Origin:  • 🇺🇸 United States • Virginia

Visit company website
AI Apply
Apply

Salary

💰 $126,000 per year

Job Level

Mid-LevelSenior

Tech Stack

Amazon RedshiftAnsibleAWSAzureBigQueryCassandraCloudJenkinsMongoDBMySQLNoSQLOraclePerlPostgresPythonRedisSQLTableauTerraform

About the role

  • Collaborate with stakeholders to understand business requirements and translate them into robust and scalable database designs
  • Design and implement database solutions that optimize performance, reliability, and security
  • Define database standards, best practices, and guidelines, and ensure adherence across projects
  • Evaluate and recommend database technologies and tools to support business needs and future growth
  • Lead database performance tuning and optimization efforts to ensure optimal system performance
  • Develop and maintain data models, schemas, and data dictionaries
  • Implement data security measures, including access controls, encryption, and data masking
  • Provide technical guidance and mentorship to junior database developers and administrators
  • Stay current with emerging technologies and industry trends in database management and incorporate them into our architecture as appropriate

Requirements

  • Proven experience as a Database Architect, Database Administrator, or similar role
  • In-depth knowledge of database management systems (e.g., MySQL, PostgreSQL, Oracle, SQL Server) and database design principles
  • Strong understanding of relational database concepts, data modeling techniques, and normalization
  • Proficiency in SQL programming and scripting languages (e.g., Python, Perl) for database automation and administration tasks
  • Experience with cloud-based database platforms (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL) and related services
  • Familiarity with NoSQL databases (e.g., MongoDB, Cassandra, Redis) and their use cases
  • Hands-on experience with database performance tuning, optimization, and troubleshooting
  • Excellent analytical and problem-solving skills
  • Effective communication and collaboration skills
  • Certification in database administration or architecture (preferred) (e.g., Oracle Certified Professional, Microsoft Certified: Azure Database Administrator Associate)
  • Experience with data warehousing and business intelligence tools (e.g., Amazon Redshift, Google BigQuery, Tableau) (preferred)
  • Knowledge of DevOps practices and tools for database automation, CI/CD (e.g., Jenkins, Ansible, Terraform) (preferred)
  • Understanding of data governance, compliance, and security standards (e.g., GDPR, HIPAA, PCI DSS) (preferred)
  • Bachelor's degree in Computer Science, Information Technology, or a related field
  • Must be a U.S. citizen; Active Public Trust/MBI or ability to obtain one
LPL Financial

AVP, Cloud Data Platforms

LPL Financial
Leadfull-time$110k–$184k / yearNew York · 🇺🇸 United States
Posted: 33 days agoSource: lplfinancial.wd1.myworkdayjobs.com
Amazon RedshiftAnsibleAWSCloudDistributed SystemsEC2ETLJenkinsMongoDBOpen SourceOraclePostgres+4 more
Protegrity

Principal Solutions Integration Architect

Protegrity
Leadfull-time$151k–$173k / year🇺🇸 United States
Posted: 7 days agoSource: jobs.ashbyhq.com
Amazon RedshiftBigQueryCassandraCloudCyber SecurityDockerDynamoDBETLJavaKubernetesLinuxMongoDB+10 more
PwC

Senior Manager, Cloud Data and Analytics – Insurance

PwC
Seniorfull-time$124k–$280k / yearCalifornia, New York, North Carolina · 🇺🇸 United States
Posted: 2 hours agoSource: pwc.wd3.myworkdayjobs.com
Amazon RedshiftAWSAzureBigQueryCloudCognosDockerETLGoogle Cloud PlatformGuidewireHadoopKafka+9 more
Parser

Senior Data Engineer

Parser
Seniorfull-time🇨🇴 Colombia
Posted: 4 days agoSource: parser.bamboohr.com
Amazon RedshiftAWSAzureCloudNumpyPandasPySparkPythonSQL
Cabify

Data Engineer, Analytics

Cabify
Juniorfull-time$42k–$42k / year🇪🇸 Spain
Posted: 2 hours agoSource: boards.greenhouse.io
AirflowAmazon RedshiftAnsibleAWSAzureBigQueryCloudDockerETLGoogle Cloud PlatformKubernetesPuppet+5 more