Associate Architect – Database Administrator
Associate Architect – Database Administrator
Refined job description
ROLE
– Design, develop, and maintain relational and/or NoSQL databases.
– Write and optimize complex SQL queries, stored procedures, functions, and triggers.
– Ensure database performance, scalability, security, and data integrity.
– Perform database tuning, indexing, and query optimization.
– Support application development teams with database design and integration.
– Manage data migration, backup, recovery, and archiving processes.
– Troubleshoot and resolve database-related issues in production and non-production environments.
– Document database designs, standards, and operational procedures.
– Monitor database health and performance
– Identifying the migration approach, Design and Build for database migration.
– Assist in backup, recovery, and security implementation
REQUIREMENTS
– Hands-on experience with MS SQL Server
– T-SQL, SQL, SSIS Oracle RDBMS, Red Hat/SUSE Linux skills
– Hands-on experience with PostgreSQL
– Strong understanding of SQL and database concepts
– Experience with Oracle Database
– Familiarity with database tools such as SSMS, pgAdmin
– Bachelor’s degree in Computer Science, Information Technology, or related field.
– Microsoft Certified: Azure Developer Associate
– Oracle Certified DBA
– 10-15 years of experience as a Database Administrator or similar role.
– Good knowledge of data modeling and database architecture.
– Hands-on experience with performance tuning and indexing strategies.
– Understanding of data security, backup, and recovery best practices.
Full job description
Job Description
The Database Administrator
is responsible for designing, developing, optimizing, and maintaining databases
to support business applications. The role ensures data integrity, performance,
and availability while working closely with application and infrastructure
teams.
Key Responsibility:
Design, develop, and maintain relational and/or NoSQL databases.
Write and optimize complex SQL queries, stored procedures, functions, and triggers.
Ensure database performance, scalability, security, and data integrity.
Perform database tuning, indexing, and query optimization.
Support application development teams with database design and integration.
Manage data migration, backup, recovery, and archiving processes.
Troubleshoot and resolve database-related issues in production and non-production environments.
Document database designs, standards, and operational procedures.
Monitor database health and performance
Identifying the migration approach, Design and Build for database migration.
Experience with SQL Server high availability technologies and disaster recovery methods.
SQL Server clustering, replication and log shipping.
Assist in backup, recovery, and security implementation
Mandatory Skills:
Hands-on experience with MS SQL Server
T-SQL, SQL, SSIS Oracle RDBMS, Red Hat/SUSE Linux skills
Hands-on experience with PostgreSQL
Strong understanding of SQL and database concepts
Preferred Skills:
Experience with Oracle Database
Exposure to cloud databases (AWS RDS / Azure SQL / GCP)
Familiarity with database tools such as SSMS, pgAdmin
Requirements
Qualification:
Bachelor’s degree in Computer Science, Information Technology, or related field.
Professional Certification Preferred:
Microsoft Certified: Azure Developer Associate
Oracle Certified DBA
MongoDB Certified Developer (Associate/Professional)
Microsoft Certified: Azure Database Administrator Associate (DP-300)
Years of Exp:
10-15 years of experience as a Database Administrator or similar role.
Job Specific Skills:
Strong experience with SQL and RDBMS (Oracle, SQL Server, MySQL, PostgreSQL).
Experience with NoSQL databases (MongoDB, Cassandra) is a plus.
Good knowledge of data modeling and database architecture.
Hands-on experience with performance tuning and indexing strategies.
Familiarity with cloud databases (AWS RDS, Azure SQL, GCP) preferred.
Understanding of data security, backup, and recovery best practices.
I'm interested
