26 Aug
|
Plodding Tech
|
Chandigarh
26 Aug
Plodding Tech
Chandigarh
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.
- Positive 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
📌 Database Administrator (Chandigarh)
🏢 Plodding Tech
📍 Chandigarh