KSU Mid-Level Database AdministratorLocation: Kennesaw, GA 30144Duration: 6 MonthsRate: $60/hr on Corp to CorpQualificationsMinimum education required: BachelorsMinimum experience required: 5Details of Duties and Percentage of Time40% - Perform code migrations in a 3-tier database/application environment (including Oracle Portal, Oracle Database, and/or MSSQL Database) and troubleshoot/resolve application issues.20% - Assist application developers in the effective use of database query and programming languages.20% - Maintain the Oracle and MSSQL Database environments, including but not limited to: installation, upgrades, and patches to all databases/instances; ensuring proper security levels are maintained; tuning; cloning; and day-to-day maintenance to ensure a high level of reliability and stability.10% - Serve as a resource on a variety of database integration issues, including migration between disparate databases, data conversion, capacity planning, and new application deployments.5% - Maintain documentation including database backup & recovery, data dictionaries and data flow diagrams as well as any documentation to meet departmental and audit requirements.5% - Other duties as assigned.Key Responsibilities• Provides support for assigned Oracle, Microsoft SQL, and/or MySQL databases.• Provides support for assigned enterprise Oracle Portal applications.• Primarily Production with some Non-Production• Creation of user accounts and assigning security access in Oracle Portal, Oracle Databases and/or MSSQL Database• Responds to database & user problems• Monitors database error logs to ensure proper capacity & availability• Install and configure database management systems and software.• Monitor and maintain databases to ensure optimal performance.• Perform backup and recovery of databases to ensure data integrity.• Provide recommendations on new database technologies and architectures.• Provide design and configuration recommendations• Other duties as assignedSkill - Required / Desired - Amount of ExperienceProven knowledge working with Oracle-based technologies - Required - 5Ability to maintain OLTP databases - Required - 5Knowledge of query languages such as PL/SQL and SQL - Required - 5Knowledge of Personally Identifiable Information (PII) data security standards. - Required - 3Knowledge of system and application security threats and vulnerabilities - Required - 5Knowledge of data backup, types of backups (e.g., full, incremental), and recovery concepts and tools. - Required - 5Experience and knowledge in code migrations, database changes, enforcement of the data integrity - Required - 3Experience and knowledge with application security management.
- Required - 3Proven knowledge working with MSSQL and/or MySQL - Highly desiredKnowledge of T-SQL query language - Highly desired