Database Administrator
- Trigyn Technologies
- 7 - 12 years
- Delhi, NCR
- 4 months ago
- Email to a friend
- Report this job
Job Description
- Database Management and Maintenanceo Design, deploy, and maintain scalable, high-performance relational and NoSQL databases (eg, PostgreSQL, MySQL, MongoDB) to support the data analytics platform
- o Perform regular database maintenance, including backups, indexing, defragmentation, and optimizing storage and retrieval processes
- o Ensure the database environment is up-to-date with security patches, software upgrades, and regular performance audits
- -Data Security and Backupo Implement robust security protocols to safeguard sensitive data, including encryption at rest and in transit, multi-factor authentication (MFA), and access control mechanisms
- o Set up and manage database backup strategies to ensure data is securely backed up, with regular restoration tests for disaster recovery
- -Performance Optimization and Tuningo Optimize the performance of database systems through query tuning, database indexing, partitioning, and storage optimization to ensure fast and reliable access to data
- o Identify and resolve database performance bottlenecks, troubleshoot slow queries, and improve data retrieval times for the dashboards
- o Monitor database performance metrics, such as response time, query efficiency, and system resource usage, using appropriate database monitoring tools
- -Data Access Control and Permissionso Implement role-based access control (RBAC) to manage and restrict data access based on user roles and responsibilities
- o Maintain a strict policy for managing user permissions, ensuring that only authorized personnel can access sensitive data
- o Regularly audit database access logs to detect and prevent any unauthorized access or suspicious activity
- -Database Scalability and Capacity Planningo Collaborate with data engineers and developers to design databases that can scale horizontally and vertically to accommodate increasing data volumes and user loads
- o Plan and manage database capacity, ensuring storage and processing capabilities grow with project requirements
- o Continuously evaluate database storage needs and implement strategies to ensure optimal use of resources, both in on-premise and cloud environments
- Data Integration and ETL Supporto Work closely with data engineers to ensure seamless data integration from multiple sources into the centralized data platform
- o Support Extract, Transform, Load (ETL) processes, ensuring that data is correctly ingested, transformed, and stored in a manner suitable for analytics and reporting
- o Troubleshoot any issues related to data synchronization, data transformation, or inconsistent data across the system
- - Monitoring and Troubleshootingo Implement and manage database monitoring tools (eg, SolarWinds, Oracle Enterprise Manager) to track database health, performance, and security in real-time
- o Troubleshoot database issues, such as connectivity problems, data corruption, or system outages, ensuring minimal downtime for the dashboard team
- o Proactively identify potential issues before they escalate, using automated alerts and early-warning systems
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: Trigyn TechnologiesLocation(s): Delhi, NCR+ View Contact
Keyskills: Computer science Performance tuning data security Postgresql MySQL Disaster recovery Oracle DBA Information technology Auditing Capacity planning
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Trigyn Technologies
Trigyn Technologies ltd Trigyn is an ISO 9001:2008 certified, and CMMI Level 5 assessed company. Trigyn Technologies is an IT Services Company that has been in business for more than 30 years. Trigyn provides IT Solutions, Consulting, Systems Integration, Managed Services, Software Development, ...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in