Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 10th Aug 2021
Remote until Covid restrictions are lifted then work on site in Long Beach
Seeking a dual-talented DBA with both SQL Server and Oracle
n this Role:
· 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.);
· Proficient in authoring, editing, presenting documents; and providing trainings to end user
· 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 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
· Microsoft Certified Database Administrator is preferred;
· Oracle Certified Database Administrator is preferred; Experience and Skills