DBA - Oracle
Duration 12 months
Location: Johnston, RI
• login to any database
• login to database using PUTTY, SQL DEVELOPER and Command prompt
• TNS entry
• Cluster experience
Summary: Responsible for coordinating changes to computer databases, test and implement the database applying knowledge of database management systems. Responsible for planning, coordinating and implementing security measures to safeguard the computer database.
Education/Experience: Bachelor's degree in computer programming or relevant field - preferred. 3+ years’ experience required.
Skills and Competencies: Verbal and written communication skills, problem solving skills, customer service and interpersonal skills. Must have a strong command of the English language, written and oral. Expert ability to work independently and manage one’s time. Expert leadership and mentoring skills necessary to provide support and constructive performance feedback. Expert knowledge of computer hardware and software. Expert knowledge of computer software, such as SQL, Visual Basic, Oracle, etc. Major Job Duties and Responsibilities: Direct programmers and analysts to make changes to existing databases and database management systems. Direct others in coding logical and physical database descriptions. Review project requests describing database user needs to estimate time and cost required to accomplish project. Review and approve database development and determine project scope and limitations. Approve, schedule, plan and supervise the installation and testing of new products and improvements to computer systems. Implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information. Perform other duties as assigned
Security DBA requirements:
Responsibilities: Security DBA will work for the Distributed IT Security team on the database security compliance tasks. Work on database security BAU task. work with DBA teams (Delivery, support) and Audit teams to review and fix any database compliance/security related issues. Shell/SQL scripting to extract security data from databases for analysis/reporting; Technical analysis of AIX, Linux and Oracle Database vulnerability findings; developing and producing written analysis of the vulnerability findings, when required. Solution development for remediation of the identified vulnerabilities, as needed. Submit/manage change management requests for security related impacts in production environments. Collect evidence confirming vulnerability remediation has been successful, as needed. Communications/Coordination with system specific Information to Audit and compliance teams. Develop and maintain documentation pertaining to Implementation Procedures, Change Control documentation, Design documents, Standard Operating Procedures (SOPs), etc Solution testing, implementation, and/or validation, as needed.
Technical requirement: Security experience with Oracle 11gR1, 11gR2, 12c. Very good understanding of Oracle database security, Database users, Database roles, Database Profiles, System privileges, object privileges, RBAC using Directory groups (Active Directory, Oracle internet directory) Good JAVA programming skills for data collection/management for databases and Directories; Extensive Unix Shell scripting skills (AIX, Linux). Familiar with Symantec CIS vulnerability scan for databases and remediation of any discovered issues; Experience with reviewing, creating and updating technical documentation Candidate must possess excellent oral and written communication skills. Knowledgeable on the regulatory requirements that impact the business lines that TSA supports (i.e. GLBA, SOX, PCI)
3-5 years in experience
financial services experience is a plus
Provisioning and following procedures
The bank currently has Oracle versions 11.x-12c
The team currently has 5 DBA's.
The contractor will be involved in building standards, net patterns, granting access, assisting current DBAs with cleanup.
This contractor will be trained to build new items to match current patterns, create logins, following governance & policies.
Other systems that the bank has includes: DB2, Neteeza, various flavors of Unix: (AIX, Redhat Linux, Solaris, and multiple appliances)
They are also looking for a SQL DBA
This position is responsible for providing second level support for Distributed IT Security team. Escalation of issues and more technical aspects of the job are required by this resource. Extensive knowledge of Oracle Security is required to provide technical expertise to both the internal/external departments within the organization. Incumbent will be instrumental in the delivery of Distributed IT Security services that align with Technology Services direction.
• 5-7 years professional experience, preferably in a financial services environment
• Minimum of 5 years IT Risk or Information Security experience, preferably in a large corporate environment
• Well versed in Oracle security architecture
• Proven service and delivery capability / focus
• Proven experience with highly complex risk issues in a technology environment and appropriate mitigation strategies.
• Knowledgeable on the regulatory requirements that impact the business lines that TSA supports (i.e. GLBA, SOX, PCI)
• Clear understanding of CoBIT and ITIL Frameworks
• Proven ability to influence and gain trust at senior management levels in multi-cultural environments
• Ability to manage complex activities simultaneously to short timescales
• Ability to demonstrate continuous improvement
• Extensive knowledge of US regulatory requirements as they pertain to Distributed I Security
• Collaborate effectively with other technical teams to improve business processes
Frontier Systems Consulting, Inc.