Port Of Los Angeles: Database Administrator

Description
Our client is seeking a Database Administrator/Architect to manage and support the Harbor Department's databases.
Certification:
Microsoft Certified Database Administrator is preferred;
Oracle Certified Database Administrator is preferred;

Duties include but are not limited to:
Install and maintain enterprise data servers including patching, upgrading, migrating, creating jobs, and setting security;
Design, develop, and implement databases and related interfaces;
Design, create, deploy, and maintain enterprise data warehouses;
Advise, plan, and manage or lead the database and application development at the enterprise level for enhancement, and data integration while setting standards and policies;
Create, manage, and maintain MS Power BI servers at the enterprise levels while ensuring usability, availability, and performance of the integrated data;
Develop standards and procedures for the testing of new databases by providing technical support such as developing utilities, maintaining systems configurations, and creating multiple test data environments, in order to prevent unauthorized access and damage to the operational databases;
Develop and implement methods and procedures for the loading of the physical database by recognizing existing data formats, knowing where to capture the data, and/or by writing programs to restructure the data;
Develop and implement methods and procedures for the reorganizing of physical databases by monitoring the frequency of the use of the database, size of the database, and activity related to the database; and decide about possible expansion of the data server or the database.
Develop and implements procedure for the backup and recovery of databases on frequency of database use and requirements of the system;
Tune and optimizes SQL statements;
Perform and support ETL processing;
Ensure database security and compliance with legal mandates and data privacy acts;
Train and assist developers and users in database use including query tools and utilities;
Assist functional and technical staff such as functional analysts, and programmers in order to
comply with data standards, maximize security, availability, and minimize error;
Develop and maintain database/system documentations;
Provide database support and coordination to various IT system upgrade projects and teams;
Perform other system and database related tasks.

Requirements:
Minimum five years of experience with database administration of medium to large databases
(200GB-1TB);
Proficient in MS SQL Server RDBMS (2012, 2014, 2016, 2019), MS Access, Oracle RDBMS (12c),
Oracle SQL, PL/SQL, SQL Loader, T-SQL, SSIS package, and scripting languages such as
PowerShell, Unix, Python;
Experience in supporting database systems on Linux OS and Windows platform;
Knowledge of IT security best practices;
Experience working with Financial, Payroll or Cloud applications is preferred;
Experience in system integration and ETL processing is preferred;
Proficiency in Microsoft Suite (Microsoft Word, Excel, and PowerPoint etc.);
Analytical skills are required to solve problems;
Work effectively with a cross-functional team, multi-tasking, and effective time management;
Proficient in authoring, editing, presenting documents; and providing trainings to end-users;
Ability to translate complex ideas into simple language for non-technical audience;
Strong interpersonal, task management, and analytical skills;
Communicate with business and technical leads clearly, persuasively, and effectively, both
orally and in writing;
Good time management and organizational skills.
Additional Skills & Qualifications
Certification:
Microsoft Certified Database Administrator is preferred;
Oracle Certified Database Administrator is preferred;
Experience Level
Intermediate Level
Benefits:
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefits
Employee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Pay and Benefits
The pay range for this position is $50.00 - $60.00

About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.