Job Description
Title: DBA (Database Administrator)
Company Name: Group of Companies
Vacancy: 1
Job Location: Dhaka
Employment Status: Full-time
Educational Requirements:
∎ Bachelor/Masters s degree in computer science, Information Technology, or a related field.
∎ Certificates:
∎ Oracle Certified Professional (OCP), OCM (Oracle Certified Master), SQL Server Administration, MySQL Database are MUST require.
∎ Value added certifications: Azure Database Administrator Associate, PostgreSQL Database Administration
Experience Requirements:
∎ At least 5 year(s)
∎ The applicants should have experience in the following area(s):
Database Administrator (DBA)
∎ The applicants should have experience in the following business area(s):
Banks, Group of Companies
Job Responsibilities:
∎ Database Design and Planning:
∎ Collaborate with application developers to understand data requirements.
∎ Design, implement, and maintain database structures, tables, and relationships.
∎ Database Installation and Configuration:
∎ Install and configure database management systems.
∎ Set up and maintain database servers, ensuring proper security and access controls.
∎ Data Security:
∎ Implement and manage data security measures, including access controls, encryption, and authentication.
∎ Regularly audit database access and take corrective actions as needed.
∎ Backup and Recovery:
∎ Develop and implement backup and recovery strategies to ensure data integrity.
∎ Perform regular backups and conduct recovery procedures in the event of data loss or system failures.
∎ Performance Monitoring and Tuning:
∎ Monitor database performance and identify areas for improvement.
∎ Optimize query performance and conduct tuning activities to enhance overall system efficiency.
∎ Database Maintenance:
∎ Apply patches and updates to the database management system.
∎ Conduct routine maintenance tasks, such as index rebuilding and database reorganization.
∎ Troubleshooting:
∎ Investigate and resolve database-related issues, such as connectivity problems and performance bottlenecks.
∎ Collaborate with other IT professionals to address system-wide issues.
∎ Documentation:
∎ Maintain comprehensive documentation of database configurations, processes, and procedures.
∎ Keep records of changes made to the database structure and settings.
∎ Capacity Planning:
∎ Monitor database growth and plan for additional capacity as needed.
∎ Anticipate and address potential scalability issues.
∎ Collaboration:
∎ Work closely with developers, system administrators, and other IT staff to ensure smooth integration of the database with other systems.
∎ Familiarity with specific database management systems (e.g., Oracle, MySQL, SQL Server).
∎ Technical Skills:
∎ Proficiency in SQL and database query optimization.
∎ Knowledge of database design principles and normalization.
∎ Communication:
∎ Effective communication skills to collaborate with cross-functional teams and convey technical information to non-technical stakeholders.
∎ Security Awareness:
∎ Understanding of database security best practices and the ability to implement security measures.
∎ Adaptability:
∎ Ability to adapt to evolving technologies and industry best practices.
∎ Team Player:
∎ Ability to work effectively as part of a team and contribute to collaborative projects.
∎ Attention to Detail:
∎ A meticulous approach to database management and the ability to spot and correct errors.
∎ The specific requirements for a DBA may vary depending on the organization, the type of database used, and the complexity of the systems involved.
Additional Requirements:
∎ Age at least 28 years
∎ Both males and females are allowed to apply
∎ Prior experience with ODI ELT /SSIS ETL of data using flat files/DB2/Salesforce/Oracle NoSQL as source
∎ Hands-on experience in troubleshooting data issues arising out of the ELT/ETL process.
∎ Design and develop SQL Server/Oracle stored procedures, functions, views and triggers to be used during the ELT/ETL process
∎ Strong and hands-on PL/SQL skillset
∎ Design, implement and maintain database objects (tables, views, indexes, ) and database security
∎ Proficient with ETL/ELT tools such as Microsoft SSIS/Oracle ODI.
∎ Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations
∎ Development experience in Oracle Apex
∎ Knowledge of database systems, data modeling, and data architecture.
Salary: Negotiable
Compensation & Other Benefits:
∎ Provident fund, Insurance
∎ Salary Review: Yearly
∎ Festival Bonus: 2
∎ Earned Leave
Job Source: Bdjobs.com Online Job Posting.
Application Deadline: 4 Jan 2024
Company Information:
∎ 24 Dec 2023
∎ Group of Companies
Category: Garments/Textile
:
