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
Full Stack Developer (Laravel + React, PHP Developer)
IT Support Engineer
Marketing Officer
IT Operations Center Administrator
IT Support Technician / Engineer / Analyst
IT Administrator, Telecommunication
IT System Administrator
Application / Software Developer
Business Intelligence Analyst, H&S
Application Developer, H&S
Technical Manager (Hardware)
Technical Manager (Software)
App Development using Flutter Trainer (Part Time / Full time)
Jr. Executive/Executive - IT
Business Development Executive, Vendor & Clint Manager
Digital Marketing Specialist
Hiring Senior Magento Developer – Remote
Executive, Software Engineer (MIS)
Executive, SD (Software Engineer)
Sr. Executive, SD (Software Engineer)
IT Executive
TRACKING EXPERT / FRONTEND DEVELOPER
Assistant Manager, Network Planning and System Solutions
MIS Officer
Technical Support Engineer
Software Engineer
Software Engineer
Full Stack PHP Developer
React Developer
Senior JAVA Developer
JAVA Developer
Flutter Developer
test_job
Senior Executive/ Executive - HR & Admin
Flutter Developer
Web Data Analytics Specialist
Senior Officer - IT
Digital Marketing
.Net Application Developer
Development Manager
Facebook Group