Oriental Control Systems
The company is seeking a talented and passionate database administrator (or DBA) to join our IT team. He/she will be playing a pivotal role in ensuring data security, data integrity, and accessibility, The DBA will be responsible for the strategic planning, managing, support, and performance tuning of all database applications, also his/her tasks including security planning, databases architecture design, performance tuning, extract-transform-load (ETL) processes, capacity planning, backups, monitoring, index maintenance, trouble shooting, maintenance plans and change control activities, building/designing APIs, building automated database backups, in other words he/she will be responsible for all activities associated with the management and operation of database platforms in the company. Furthermore, the database administrator ensures that data leaks are not present within our systems, and that all data is staying compliant according to our company policies. There will be close collaboration with data analysts, software applications developers, server operations administrators, and product/project managers.
JOB ROLES & RESPONSIBILITIES:
– Designs, develops, installs, tests, maintain and performance tune all company Production, Test & Development databases including but not limited to oracle and sql server; includes the design of database objects such as tables, indexes, views, functions, and stored procedures and ensure compliance with RDBMS licensing;
– Lead the design and construction of highly available and secure databases, data warehouses, data marts, and business intelligence platforms;
– Support company sites operations in a high-throughput production environment by proactively managing the performance, integrity, and security of company Applications’ databases and database servers;
– Maintain data integrity and monitor security by setting up and manage roles and permissions for authorized database users;
– Ensures compatibility and efficiency of database applications;
– Performs system, database and job monitoring, to include database health checks, and takes action to remedy any identified issues;
– Using automated tools to extract data from primary and secondary sources, and removing corrupted data and fixing coding errors and related problems;
– Create and maintain customized database reports and perform data analysis using Business
Intelligence tools like PowerBI, Reporting Services , and Analysis Services;
– Responsible for synchronizing and migrating data and database objects between development, quality assurance, and production environments;
– Upgrades, clones and manages existing and future database systems;
– Developing complex database processes with PL/SQL, and create scripts and SSIS packages for data integration ETL, data maintenance or bug fixes;
– Develop, recommend and present database roadmap including performance, capacity planning, monitoring, replication, backup and recovery and automation tools;
– Setup, monitor, and maintain disaster recovery solutions for production databases, and manage the security and disaster recovery aspects of a database;
– Analyze user concerns, requirements and requests for system features and uses; identify applications, modifications and enhancements and implement appropriate solutions;
– Monitor, forecast and provide new requirements of DASD Storage;
– Maintain all IMS HALDB, Full Function databases and DB2 structures;
– Design, implement and manage database backup/recovery and high availability strategy, to support the strategic database environment;
– Troubleshoot performance and stability issues and apply service packs and hot fixes;
– Manage database clustering and monitor server high availability, schedule jobs, replication, and failover;
– Ensure IMS databases and DB2 structures are properly reorganized for maximum performance;
– Developing and enhancing an existing DataMart in an OLAP schema;
– Configuration, managing, monitoring, maintenance and troubleshooting of SQL/PL Database Servers and maintains them at high availability and high performance;
– Ensure IMS databases and DB2 structures are properly reorganized for maximum performance;
– Tunes Oracle PL/SQL packages, procedures and functions;
– Develop and maintain T-SQL procedures, views, functions, and other scripts in support of product development, customer reporting, and database administration requirements;
– Execute Oracle/SQL upgrades installation, configuration and administration knowledge transfer to company clients so they can become self-sufficient;
– Write high performance SQL/PL queries and stored procedures.
– 24×7 production support and call support in responding to problems and outages;
– Respond to alerting systems in a timely manner and quickly be able to identify, troubleshoot and remediate problems or upgrade interfaces;
– Consulting with operating systems, software developers, security and network staff to evaluate the requirements of installation new database or modifications of an existing database.
– Ensure required documentation is in-place and up to date for all database management solutions and operating manuals;
– Handling clients training and support and responding to their feedback;
– Run diagnostics and maintain operation logs and database documentation, including data standards, procedures and definitions for the data dictionary (metadata);
– Provides key statistics and performance measures related to database systems;
– Perform tests and evaluations regularly to ensure data security, privacy and integrity;
– Collate, prepare and present statistical information for internal and external use;
– Assist in the management of the hardware and software as related to the operations of the database technology servers, including system development, maintenance, and recommendations of purchases of new hardware and software;
SKILLS & EXPERIENCE:
– Bachelors’/Master’ of science degree from an accredited college in Computer Science/Information Systems, Software Engineering, Management Information Systems, math, or other closely related technical field;
– Database Administrators are most likely to hold a combination of the following certifications:
– Microsoft Certified Solutions Expert Data Platform and Business Intelligence (MCSE):
– Microsoft Certified Database Administrator (MCDBA),
– Oracle Certified Professional – Oracle 9i Database Administrator (OCP)
– Oracle Certified Associate – Oracle9i Database Administrator (OCA)
– IBM DBA Certifications.
– MySQL for Database Administrators and Performance Tuning (MySQL)
– Project Management Program (PMP) certification a plus
EXPERIENCE & SKILLS:
– 7+ years of direct experience in database management skills with contemporary relational databases, and in high volume and large database environments including administrative configuration, reporting, dashboards and data quality skills and maintaining multiple large database systems consisting of normalized and denormalized data and table structures;
– 5+ years of experience in managing highly available production databases system in multi technology environment;
– Must be able to organize and prioritize work, be proactive, take initiative, resolve problems, follow through, and simultaneously manage multiple priorities to ensure goals are met in a timely manner;
– Extensive previous experience with DBA case tools (frontend/backend) and third party tools;
– Extensive experience and skills and Strong command with database technologies of SQL and SQL server tools, Oracle and IBM (MySQL, MSSQL, PostgreSQL Oracle, MongoDB), and Unix shell scripting skills;
– Extensive Experience with cloud services (AWS, Microsoft Azure);
– Excellent skills in understanding of relational and dimensional data modelling and create sustainable and maintainable environments;
– Advanced knowledge of database security, integrity, backup and recovery, and performance monitoring standards, and Hands-on experience with database standards and end user applications;
– Familiarity with programming languages API, and Hadoop;
– Strong mathematical and statistical knowledge;
– Deep experience with Linux, Windows Server environments, TSQL, Powershell;
– Proficient in data warehouse, Extraction transformation and loading (ETL) operations using (but not limited to) SSIS (integration Services), Python, Teradata DBA, Java, Big data, Linux;
– Excellent ability to Automate and innovate new ways to manage large database clusters;
– Experience with DBA case tools (frontend/backend) and third party tools;
– Excellent skills in problem-solving which needed to work with complex database systems, and ability to think algorithmically;
– Good understanding of general web concepts (HTML Java script and authentication) in order to liaise with web team for on-line forms and integrations;
– Should be able to communicate well, work on teams, and catch small details in their work;
– Ability to provide key data recommendations and best practice solutions to project teams and governance committees as requested;
– Experience with physical data modelling and designs techniques include implementing data models, creating database tables, use of indexes, materialized views, system aggregates, etc, to support new and existing applications and structured programming, testing and debugging techniques;
– System architecture, including database and system performance tuning, as well as hardware and network workload balancing experience;
– Good knowledge in Hive for distributed databases, Spark for Data Analytics;
– Strong ability in adept at interacting and collaborating and working with system developers team and IT;
– Expert in design and maintenance of company database systems;
– Hands-on experience with database standards and end user applications;
– Experience implementing virtual data marts;