Database Administrator - Onsite

Title:

Database Administrator - Onsite Mandatory skills: Oracle, MySQL data base management technologies, UNIX operating system, LINUX operating system, Microsoft SQL Server, Windows operating system, MySQL internals, data structures, memory management, Oracle network connectivity, SQL, PL/SQL languages, commands, Microsoft Server operating system, computer programming, systems analysis, systems design principles, MySQL software, databases, database backup, recovery procedures, RMAN, data base parameters, performance tuning, Oracle

PL/SQL, UNIX

shell scripts, LINUX shell scripts, Windows operating system

BAT, CMD

shell scripts, database design, database administration, computer programs, stored procedures, quality control, test procedures

Description:

Database Administrator responsibilities include but may not be limited to the following: Management and administration of Oracle, Microsoft SQL Server and MySQL database software and databases; Installing, configuring, patching and maintaining Oracle, Microsoft SQL Server and MySQL database software and databases; Ensuring the availability, integrity and security of database data; Providing database backup and recovery services; Developing and maintaining utility programs, scripts and routines for management of database systems on Red Hat LINUX and Windows server systems; Providing network support services for database-related network technologies and adapters such as TNS, ODBC, JDBC, OLEDB and .Net; and Assisting in the establishment and enforcement of database administration policies, standards and procedures. Collaborating with business experts to develop and document database infrastructure or design requirements; Performing database design, data modeling and data administration; Developing and documenting data standards Maintaining the enterprise data dictionary and model repository; Utilizing data administration tools to construct data profiles, perform data analysis and provide data cleansing recommendations; Providing support, diagnostic, troubleshooting and resolution of web-based and client server software applications in a distributed computer systems environment; Project planning related to maintenance and lifecycle management for multiple distributed systems; Administration and support for multiple statewide applications; and

KNOWLEDGE, SKILLS & ABILITIES

Knowledge of Oracle and MySQL data base management technologies in

UNIX/LINUX

operating system environment; Knowledge of Microsoft SQL Server in a Windows operating system environment; Knowledge of Oracle, Microsoft SQL Server and MySQL internals, data structures, and memory management; Knowledge of Oracle network connectivity; Knowledge of SQL and PL/SQL languages; Knowledge of

UNIX/LINUX

operating system and commands; Knowledge of Microsoft Server operating system and commands; Knowledge of computer programming, systems analysis and systems design principles and practices; Experience installing and maintaining Oracle, Microsoft SQL Server and MySQL software and databases; Experience designing, developing, testing, documenting and implementing database backup and recovery procedures; Experience performing database backup and recovery processes for Oracle using RMAN; Experience performing database backup and recovery processes for Microsoft SQL Server; Experience configuring data base parameters for performance tuning; Experience developing, testing, documenting and implementing SQL, Oracle

PL/SQL, UNIX/LINUX

shell scripts and Windows operating system BAT orCMD shell scripts; Ability to use critical thinking skills and problem solve; Ability to work independently; Ability to create logical, well-written standards and procedures related to database design and database administration; Ability to write, code, test, debug, and review computer programs and stored procedures; Ability to process information logically and solve problems; Ability to identify and define user requirements; Ability to communicate effectively verbally and in writing; Ability to establish and maintain effective working relationships with others;

Preferred Experience:

8 years of experience working with Oracle RDBMS software and databases (version 11g or more recent) 8 years of experience developing

SQL, PL/SQL

scripts, procedures, functions and packages 5 years of experience planning, developing and executing data conversion/migration plans, processes and programs Experience facilitating analysis sessions with business clients Experience presenting technical subject matter reviews or seminars to business clients Experience designing and executing quality control and test procedures The Database Administrator will report to the designated client supervisor, and is expected to perform the tasks and specific assignments given by the client supervisor.

VIVA USA

is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of

VIVA USA

shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.

Contact Details :

Account co-ordinator: Binodh

M.T VIVA USA INC.

3601 Algonquin Road, Suite 425 Rolling Meadows, IL 60008 |