Database Administrator
Job Description
Title: Database Administrator
Company Name: A Group of Company.
Vacancy: 01
Job Location: Dhaka
Employment Status: Full-time
Educational Requirements:
∎ Bachelors Degree in Computer Science or Information Systems; or equivalent combination of education and relevant experience.
Experience Requirements:
∎ At least 7 year(s)
∎ The applicants should have experience in the following area(s):
AWSAzure Cloud Administration, Azure SQL, Microsoft SQL server, Oracle Database
∎ The applicants should have experience in the following business area(s):
Software Company, Group of Companies
Job Responsibilities:
∎ Proactively monitor the database environment and make changes to data structures, SQL, application logic, and the DBMS subsystem to optimize performance.
∎ Working knowledge of MS SQL Server RDBMS Architecture and HA technologies such as Always ON Availability Group, Replication, Mirroring, Log Shipping.
∎ Refine and automate regular processes, resolve and track issues, and document changes.
∎ Ensure database backups are being done as scheduled and recover databases as needed.
∎ Maintain and periodically test the backup/recovery strategy by refreshing the DEV, TEST, and TRAIN Environments.
∎ Deep knowledge of Oracle RDBMS Architecture and technologies such as RMAN, Data Guard, Golden Gate, Real Application Testing, Advanced Compression, and partitioning features.
∎ Create/maintain efficient, well-documented custom PL/SQL, T-SQL scripts, stored procedures, and triggers following defined business rules and requirements.
∎ Install/configure databases (SQL Server, Oracle, etc.), and apply service and feature packs (On-Premises and Azure).
∎ Upgrade databases to newer versions and migrate databases using Azure.
∎ Experienced in managing and maintaining Azure SQL Databases in IaaS, PaaS, and Managing Azure Platform.
∎ Create and maintain BI ETL processes to efficiently load the data warehouse or data mart with large volumes of data extracted from multiple existing production systems
∎ Possess in-depth SQL knowledge to complete code reviews and walk-through and assist developers with complex query tuning and schema refinement.
∎ Troubleshoot and resolve database issues quickly.
∎ Predict growth based on application and data usage patterns and implement the necessary database changes to accommodate that growth.
∎ Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, etc., and detect and troubleshoot SQL Server / Oracle-related CPU, memory, etc. I/O, disk space, and other resource contention problems.
∎ Conduct system tuning, performance monitoring, and database maintenance.
∎ Maintain database security and set up user accounts to control logins to the database.
∎ Advanced knowledge of database structure.
∎ Apply data modeling techniques to ensure integration and performance expectations are met and allow for future flexibility.
∎ Design and model significant transaction and reporting databases as well as Data Warehouses and Cloud Databases.
∎ Translate data models or logical database designs into physical database schemas, tables, and dictionaries.
∎ Collect, store, manage, and provide the ability to query metadata.
∎ Knowledge of Database Encryption (On-Premises, Azure).
∎ Working Knowledge with Azure Data Lake, Azure Synapse Analytics, Azure Cosmos DB (NoSQL).
Additional Requirements:
∎ Age 27 to 35 years
∎ 7+ years of Administration Experience with SQL Server (2014,2016,2019) and Oracle 12c.
∎ 3+ years of experience with the Microsoft Azure platform, including Azure Data Factory, Data Lakes, Blob Storage, Azure SQL, and recent SQL synapse analytics experience.
∎ Experience with supporting ERP and CRM applications like Microsoft Dynamics CE and F&O preferred (On-Premises, D365).
∎ The applicants should have experience in the following business area(s):
∎ Software Company, Group of Companies.
∎ Certifications or direct experience in Oracle, SQL Server, or Cloud Platforms (Azure) preferred.
∎ Advanced working SQL knowledge and experience working with relational databases, structured, semi-structured, and unstructured data, query authoring as well as optimizing the database objects
∎ Experience in supporting HA solutions for Oracle, SQL Server (On-Premises, Azure).
∎ Open to learning and exploring new technologies to support ZONES business goals.
∎ Good communication and teamwork skills.
Salary: Negotiable
Compensation & Other Benefits:
∎ Salary Review: Yearly
∎ Festival Bonus: 2
∎ As per company rules
Job Source: Bdjobs.com Online Job Posting.
Application Deadline: 30 Nov 2021
Company Information:
∎ 15 Nov 2021
∎ A Group of Company.
∎ Business : 100% Export Oriented Knitted Garments, Lingerie, Sweater and Garments Accessories Manufacturing Industry.
Category: IT/Telecommunication
: Those who doesn't have experience in relevant field please don't apply.
Source: bdjobs.com
Deadline Expired on 30th Nov 2021
Similar Jobs
Senior Executive; ICT Sales!
Sr. Software Engineer (PHP & ReactJS)
IT System Engineer (Network and Server)
Deputy Manager (IT)
Manager, IFS - Information Technology
Software Engineer (Laravel, React JS)
Tech Lead / Sr. Backend Engineer (Java)
Senior Executive- Graphics Designer /Motion Graphics Designer
Senior Executive - Digital Marketing
IT Support Engineer
Senior Developer - 52LEASING
Data Analyst
Senior Executive; System Admin(IT Personnel)
Full-stack Laravel Developer
Executive
Web Developer (PHP & Laravel)
Front End Engineer
Web Developer/ Software Engineer (.Net)
React Native Developer
SEO Specialist
MERN Stack Developer (Backend Focus)
Front-End Engineer and Designer
Database Developer, Designer and Programmer
IT Executive
Executive (Networking) - ICT
Junior Executive, Information Technology
Executive / Sr. Executive - Information Technology (IT).
Account Manager (Large Enterprise & ISP)
Core Service Specialist Engineer
UX/UI Designer
PMO Manager
Trainee Engineer
Software Engineer (.NET)
Manager (Oracle EBS)
Junior Officer - IT
Flutter Mobile App Developer (Android/iOS)
Jr./Mid/Sr. Backend Engineer (PHP/Laravel)
IT Executive
UI/UX Designer
Executive/ Sr. Executive- IT
Facebook Group