Database Administrator

Plodding Tech; Chandigarh; On-site; INR 700,000 - 1,000,000; Full time

Job summary

Plodding Tech in India invites an experienced Database Administrator to manage SQL Server databases, ensure high availability, and implement backups and disaster recovery plans.

You will optimize queries, design ER diagrams and DFDs, monitor performance, and collaborate with developers and IT teams to maintain security and data integrity. A minimum of 3 years’ experience and a degree in IT/CS are required.

Qualifications

• Minimum 3 years of professional experience as a Database Administrator or similar.
• Graduate or postgraduate degree in IT/CS or related field.
• Strong hands-on experience with Microsoft SQL Server 2012 and 2019.
• Knowledge of ER diagrams and data flow diagrams.
• Experience with backup, restore, security, and performance tuning.
• Ability to design and interpret ER diagrams and DFDs.
• Collaborative and able to work with IT teams.

Responsibilities

• Manage, maintain, and monitor SQL Server databases for availability and performance.
• Install, configure, maintain, backup, and recover databases.
• Monitor performance and resolve issues.
• Write and optimize SQL queries, stored procedures, views, and other objects.
• Support disaster recovery and migrations.
• Manage database security, users, roles, and access.
• Troubleshoot connectivity and data integrity problems.
• Collaborate with developers and IT teams.
• Maintain documentation and technical specs.
• Work with ER and DFD diagrams as needed.

Skills

SQL Server 2012

SQL Server 2019

ER diagrams

DFD diagrams

Database security

Backup & recovery

Performance tuning

Troubleshooting

SQL

Independent work

Education

Bachelor's degree in IT / Computer Science / Information Technology

Tools

SQL Server Management Studio (SSMS)

Job description

Key Responsibilities

• Manage, maintain, and monitor SQL Server databases to ensure availability, performance, and reliability.


• Perform database installation, configuration, maintenance, backup, and recovery activities.


• Monitor database performance and identify and resolve performance-related issues.


• Write, review, and optimize SQL queries, stored procedures, views, and other database objects.


• Perform database backup and restore operations and support disaster recovery activities.


• Manage database security, user accounts, roles, and access permissions.


• Troubleshoot database errors, connectivity issues, and data integrity problems.


• Support database upgrades, migrations, and maintenance activities.


• Maintain appropriate database documentation and technical specifications.


• Understand and work with SQL Server 2012 in production/support environments.


• Have working knowledge of SQL Server 2019 and its features and capabilities.


• Design and maintain Entity Relationship (ER) diagrams and Data Flow Diagrams (DFD) as required.


• Collaborate with developers, system administrators, and other IT teams to resolve database-related issues.


• Follow organizational standards for database security, backup, recovery, and data integrity.

Required Skills & Qualifications

• Minimum 3 years of professional experience as a Database Administrator or in a similar database-focused role.


• Graduate or Postgraduate degree in IT, Computer Science, Information Technology, or a related discipline.


• Strong hands-on experience with Microsoft SQL Server 2012.


• Good knowledge of SQL Server 2019.


• Strong understanding of database administration and management concepts.


• Good knowledge of SQL, database objects, stored procedures, views, functions, and indexing.


• Knowledge of database backup, restore, recovery, and performance tuning.


• Ability to design and interpret ER diagrams and DFDs.


• Good analytical and problem-solving skills.


• Ability to work independently as well as collaboratively with technical teams.

Preferred Skills

• Experience with database migration or SQL Server upgrades.


• Knowledge of database security and access management.


• Familiarity with high availability and disaster recovery concepts.


• Knowledge of database monitoring and performance optimization tools.


• Good documentation and communication skills.

Key Competencies

• Database Administration


• SQL Server Management


• SQL Query Optimization


• Database Performance Tuning


• Backup & Recovery


• Database Security


• ER & DFD Diagram Design


• Troubleshooting & Problem Solving


• Documentation and Team Collaboration