في المكتب دوام كامل
--
Vistas Global

تفاصيل الوظيفة

Job Summary We are seeking an experienced Senior Database Administrator / Database Systems Engineer to administer and support campus-wide relational databases across production, instructional, development, and enterprise computing environments. The ideal candidate will have strong expertise in Oracle Database, Microsoft SQL Server, and Postgre SQL, with hands-on experience in database administration, performance tuning, security, backup and recovery, disaster recovery, data warehousing, ETL, data integration, and business intelligence. The role will be responsible for maintaining high availability, database integrity, security, performance, and reliability across enterprise systems. Key Responsibilities1. Database Administration Administer campus-wide relational databases supporting production, instructional, development, and enterprise systems. Install, configure, maintain, upgrade, and monitor database management systems. Support Oracle Database, Microsoft SQL Server, and Postgre SQL environments. Perform routine database maintenance and administration. Ensure databases remain on the latest stable supported versions. Maintain database availability, reliability, and performance.2. Database Objects & Security Administration Create and manage:Schemas Tables Tablespaces Indexes Views Queries Stored Procedures User Roles User Profiles Control and monitor database access. Manage database security configurations and permissions. Monitor database security tools and ensure appropriate security controls are maintained. Monitor audit logs and database activity logs.3. Database Performance & Optimization Diagnose and resolve database and system issues. Perform database performance tuning and optimization. Analyze database resource utilization and capacity requirements. Optimize the placement and management of:System executables Redo logs Data files Application data files Index files Monitor disk space and database storage utilization. Support capacity planning and infrastructure optimization.4. Backup, Recovery & High Availability Design and maintain enterprise database backup and recovery strategies. Ensure databases are regularly backed up and recoverable. Develop and maintain Disaster Recovery (DR) and Business Continuity solutions. Perform database recovery testing. Ensure data integrity and availability. Diagnose database failures and restore services within required operational timelines.5. Data Warehouse & Data Mart Design, develop, and maintain enterprise data warehouses and data marts. Support data architecture and analytical data environments. Develop data structures to support reporting and business intelligence requirements. Implement and maintain ETL processes.6. ETL, BI & Data Integration Design and implement ETL processes using appropriate tools. Support BI reporting and analytics solutions. Develop and maintain Power BI reporting solutions. Support data integration between enterprise databases and third-party applications. Ensure accurate and reliable data exchange between systems. Support Data Mart and Data Lake initiatives where applicable.7. Data Modeling Develop data models for new and existing enterprise applications. Create and maintain Entity Relationship Diagrams (ERDs). Analyze business and end-user requirements. Design database structures that support application functionality. Recommend appropriate tables, fields, indexes, relationships, and stored procedures.8. Database Development & Enhancement Modify and enhance database objects to support new system functionality. Add or modify:Tables Fields Indexes Stored Procedures Views Support database changes required for application upgrades and enhancements. Collaborate with application development teams to ensure database changes meet system requirements.9. Database Security & Compliance Develop and monitor policies and procedures governing data integrity and access. Ensure appropriate access controls are implemented. Monitor database audit logs. Investigate unauthorized or suspicious database activity. Maintain compliance with organizational data-security requirements. Protect enterprise data against unauthorized access and loss.10. Database Storage & Disk Management Perform disk management activities required for database installations and operations. Monitor database storage capacity and availability. Manage database files and storage allocation. Optimize database file locations and storage utilization. Ensure sufficient disk space for database operations, logs, indexes, and application data.11. Troubleshooting & Production Support Investigate and resolve database and system problems. Provide database support for production and enterprise applications. Perform root-cause analysis for database incidents. Coordinate with application, infrastructure, and systems teams to resolve issues. Maintain high availability for enterprise computing systems.12. AI & Emerging Technologies Stay informed about AI tools and Generative AI technologies relevant to database administration, analytics, and enterprise systems. Evaluate opportunities to leverage emerging technologies to improve database operations and reporting. Required Qualifications Education Bachelor's degree in:Computer Science Information Technology Computer Engineering Information Systemsor another technology-related field Degree must be from an accredited college or university. Required Experience6–8 years of academic and research application development experience. Strong hands-on experience installing, configuring, tuning, and managing:Oracle Database Microsoft SQL Server Postgre SQLExperience designing and maintaining enterprise database environments. Strong experience in database backup, recovery, disaster recovery, and business continuity. Experience with database performance tuning and capacity planning. Experience with database security and access management. Experience with data modeling and enterprise database design. Experience with ETL and data integration. Preferred Skills

وظائف مشابهة

حول Vistas Global
قطر, الدوحة
مصرفي