KSU Mid-Level Database Administrator
[Atlanta, GA, 30304] | 2020-10-07 09:30:39
Share Job
Job Code : 637801
Job Title: KSU Mid-Level Database Administrator
Location: Kennesaw, GA 30144
Duration: 6 Months
Locals Only
Rate: $60/hr on Corp to Corp
Qualifications
Minimum education required Bachelors
Minimum experience required 5
Details of duties and percentage of time
40% - 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 assigned
Skill | Required / Desired | Amount of Experience |
Proven knowledge working with Oracle-based technologies | Required | 5 |
Ability to maintain OLTP databases | Required | 5 |
Knowledge of query languages such as PL/SQL and SQL | Required | 5 |
Knowledge of Personally Identifiable Information (PII) data security standards. | Required | 3 |
Knowledge of system and application security threats and vulnerabilities | Required | 5 |
Knowledge of data backup, types of backups (e.g., full, incremental), and recovery concepts and tools. | Required | 5 |
Experience and knowledge in code migrations, database changes, enforcement of the data integrity | Required | 3 |
Experience and knowledge with application security management. | Required | 3 |
Proven knowledge working with MSSQL and/or MySQL | Highly desired | |
Knowledge of T-SQL query language | Highly desired |
Any Graduate