Associate Architect - Database Administrator
Esyasoft Technologies Private Limited · Bengaluru, Karnataka, India
Utilities · 1,001-5,000 employees
About the role
The Database Administrator is responsible for designing, developing, and maintaining relational and NoSQL databases to ensure optimal performance, security, and data integrity. They will also manage database migrations, backups, and recovery processes while supporting application development teams.
What they look for
Requirements
Candidates must hold a bachelor's degree in Computer Science or a related field and possess 10-15 years of experience in database administration. Strong hands-on expertise in MS SQL Server, Oracle, and PostgreSQL is required, along with proficiency in database tuning and architecture.
Full 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.
