Database Administration

DBMS: Oracle, Microsoft SQL Server, MySQL, PostgreSQL, MongoDB, Cloud based Databases, Bigdata technologies.

Scripting: SQL, PL/SQL, Shell, PowerShell.

Tools: pgAdmin, SSMS, Oracle Enterprise Manager, AWS RDS, Azure SQL, etc.

Backup solutions, monitoring tools, and performance tuning utilities.

Minimum Qualifications:

Degree or equivalent qualification; 2-3 years of Database Administration experience.

Database Management & Maintenance

1. Install, configure, and upgrade database management systems (DBMS) such as Oracle, SQL Server, MySQL, PostgreSQL, etc.
2. Perform routine maintenance including backups, updates, and patches.
3. Monitor database performance and tune for efficiency (indexing, query optimization, etc.).
4. Manage database storage and capacity planning.

Security & Compliance

1. Implement and manage database security policies including user access controls and data encryption.
2. Ensure compliance with data protection regulations (e.g., GDPR, HIPAA).
3. Regularly audit databases for potential security vulnerabilities.

Backup and Recovery

1. Develop and maintain robust backup and disaster recovery strategies.
2. Perform regular data backups and test restoration procedures.
3. Respond quickly to restore data in the event of a failure or breach.

Monitoring & Performance Tuning

1. Monitor database activity and usage.
2. Analyze slow-running queries and make recommendations for optimization.
3. Use tools to track performance metrics and proactively resolve bottlenecks.

Data Integrity & Quality

1. Ensure data consistency, accuracy, and availability.
2. Manage data import/export processes and ETL operations if applicable.
3. Set up and maintain database replication and synchronization.

User & Role Management

1. Create and manage user roles and permissions based on access needs.
2. Support internal teams with database-related issues and requests.
3. Work closely with developers, IT staff, and business analysts to support application and data needs.
4. Support development and testing environments with appropriate data and configurations.
5. Document database systems, configurations, policies, and procedures.

Automation & Scripting

1. Develop scripts for routine tasks such as backups, monitoring, and user provisioning.
2. Automate repetitive processes for improved efficiency.