Database Architect

Required Skill Set (Must Have)

• Understanding of various relational and non-relational database technologies along with their benefits, downsides, and best use-case.
• In-depth experience in configuring database replication on multiple versions.
• Strong experience in Monitoring, DB Performance Tuning, DB Availability, DR, Security, Storage
• Analyzing and providing recommendations to optimize database
• for improved performance, manageability, and scalability.
• Expertise in enterprise backups, recovery, and performing point in-time recovery
• Experience in deploying and integrating PMM tools
• Experience in data partitioning and encryption.
• Knowledge of de-facto standards and best practices Relational and No-SQL DBs
• Understanding storage of Structured and Non Structured Data.
• Ability to plan resource requirements from high level specifications
• Design and implement effective mission-critical database solutions
• Conceptual, logical data models and physical database design using tools like Erwin, PGAdmin, Visio, UML
• Hands on experience and Proficient in SQL and procedural languages (i.e. PL/SQL, T-Sql, PL/PgSql)
• Understanding of Data warehousing, ETL processes, and Report Functions
• Database security, database hardening, data encryption at rest and at motion
• Implementing normalized and deformalized star and snowflake schema

Desired Skill Set (Good to Have)

• Data migration knowledge- Homogenous and heterogeneous e.g. MongoDB to PostgreSQL with tools like Goldendale, Ora2PG.
• Database backup knowledge (physical and logical) and recovery strategies.
• High availability and disaster recovery principle i.e. physical and logical standby databases, server clustering, mirroring, replication, sharding
• Performance tuning i.e. database initialization parameter tuning, database tuning, query and Pl/Sql tuning
• Good understanding of code versioning tools such as Git / Mercurial / SVN