MID-LEVEL DATABASE ADMINISTRATOR

EMPLOYER: 4CONSULTING, INC.

JOB TITLE: MID-LEVEL DATABASE ADMINISTRATOR

EDUCATION & EXPERIENCE: Master’s Degree in Computer Applications, Computer Information Systems or foreign equivalent and six (6) months of experience in the job offered or six (6) months of experience writing code for Client-Server applications using Oracle 19c/12c/11g/10g/9i/8i versions with tools PL/SQL Developer, SQL *PLUS, TOAD and SQL*LOADER. Developing and creating Oracle-centric (SQL, PL/SQL) concepts such as Packages, Procedures, Functions, Triggers, Views, and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle. Writing Complex SQL Query's using join’s, subquery’s, indexes, and constraints for client adhoc requirements. 

DUTIES: Design and develop logical and physical data models to support application requirements and business objectives. Collaborate with stakeholders, including business analysts, and project managers, to understand data requirements and translate them into effective database designs. Normalize data structures to ensure data integrity, minimize redundancy, and optimize query performance. Develop and maintain processes to import data from various sources into the database using ETL tools, ensuring accuracy, completeness, and consistency. Implement data transformation and cleansing routines to standardize and validate incoming data and resolve data quality issues. Schedule and automate data import tasks using tools like IBM DataStage, PL/SQL, or custom procedures to streamline data integration workflows. Monitor data import processes for errors, exceptions, and performance bottlenecks, and troubleshoot and resolve issues as needed. Configure database monitoring tools and utilities, such as IBM DB2 Data Server Manager or native database monitoring features, to track database performance metrics and identify potential problems. Monitor database health, resource usage, and query performance to detect anomalies, bottlenecks, or inefficiencies. Analyze query execution plans, index usage, and database statistics to identify opportunities for performance optimization and query tuning. Proactively address performance issues by adjusting database configurations, optimizing SQL queries, writing packages and procedures, indexes, advanced SQL techniques, and fine-tuning database parameters. Develop and document database security policies, standards, and guidelines to mitigate risks, protect sensitive data, and ensure regulatory compliance. Define data validation rules, constraints, and business logic to enforce data integrity constraints, such as referential integrity, entity integrity, and domain integrity. Implement data quality measures and validation checks to identify and prevent data anomalies, errors, or inconsistencies. Perform routine database DBA administration tasks, such as database, tables, indexes, procedure, packages and triggers creation, schema management, and user access control, to ensure the integrity and security of the database environment. Manage and maintain the organization's DB2 and Oracle databases, ensuring they operate efficiently, securely, and reliably. Configure and maintain computerized databases backups, replication, and high availability solutions to minimize data loss and ensure business continuity. Implement script changes to the database environment, such as Procedures, packages, Indexes, and schema modifications Using DB2, SQL, PL/SQL, data migrations, and performance optimizations, in coordination with development and operations teams. Write Code for Client-Server applications using Oracle 19c/12c/11g/10g/9i/8i versions with tools PL/SQL Developer, SQL *PLUS, TOAD and SQL*LOADER. Develop and create Oracle-centric (SQL, PL/SQL) concepts such as Packages, Procedures, Functions, Triggers, Views, and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle. Write Complex SQL Query's using join’s, subquery’s, indexes, and constraints for client adhoc requirements.  Write Complex SQL Query's using join’s, subquery’s, indexes, and constraints for client adhoc requirements.  Deploy and configure database changes Script changes and related tools using DB2, ensuring they align with organizational requirements and industry best practices. Collaborate with stakeholders to understand business requirements and translate them into database design and infrastructure plans. This includes capacity planning, scalability considerations, and disaster recovery planning. Provide support to other application developers by assisting with database design, query optimization, and troubleshooting database-related issues in development and testing environments. Contribute to the smooth operation and optimization of computerized databases, supporting the organization's business objectives effectively using database technologies such as Oracle SQL, PL/SQL, DB2.

LOCATION: McKinney, Texas. 40 Hours/week. M-F. Job will require domestic travel to client sites with expenses paid by employer. Must be authorized to work in the U.S. Email resumes to hr@4ci-usa.com or mail to Attn: HR, 4Consulting, Inc., 6850 TPC Drive, Suite 208 McKinney, Texas 75070. Please use Job ID: 3013 when applying.