Experience: 4+ Yrs
Job Type: Full Time
Job Location: Client Place
Job Description
ROLES
1. Identify user needs to create and administer databases.
2. Design and build new databases.
3. Ensure that organizational data are secure.
4. Backup and restore data to prevent data loss.
5. Ensure that databases operate efficiently and without error.
6. Make and test modifications to database structure when needed.
7. Maintain databases and update permissions.
RESPONSIBILITIES
- Manage databases through multiple product lifecycle environments, from development to mission-critical production systems.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Refine and automate regular processes, track issues, and document changes
- Assist developers with complex query tuning and schema refinement.
- Provide support for critical production systems.
- Perform scheduled maintenance and support release deployment activities after hours.
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
- Creates table design , objects , maintains data relationships , encrypt and data security, Data maintenance jobs.
- Create database , HA Architecture , Archiving , Clustering , DB Upgrades/installation, server sizing, Data warehouse design and create, Database maintenance jobs
- Create ETL jobs for data transfer from Production DB to MDW.
- Required Database knowledge : Mongo DB , PostgreSQL , SQL Server