Location: Richmond, VA\rDuration: 6 months with possible contract to hire\r\rDescription:\rPostgreSQL and Oracle database administration on the Unix environment skills needed.\rManaging RDS instances and EC2 in AWS skill set is must. \r\r- Communication skills and general DBA experience\r- Highly motivated, job engaged, Team player\r- Good verbal and written communication skills, able to clearly articulate complex technical issues and relate to development requirements and needs. \r- Should be able to work across physical boundaries through phone, IM efficiently \r- Physical modeling experience needed - preferably in Erwin modeling tool\r- Batch Jobs scheduling experience - preferably control-m tool\r- Candidates should have experience in large-scale environments\r- Hands on experience with Microsoft Windows XP or higher version, Office, PowerPoint, Access, Visio and Project \r- Strong change management experience for implementing database changes\r- Experience promoting database objects from one environment to other and maintaining change logs\r- Oracle DBA experience \r- Creation of databases in HPUX / AIX environments\r- High level experience with writing Korn shell scripts\r- Very good understanding of how memory, CPU, Disks work on the UNIX environment\r- Demonstrate experience with backups, recovery, performance tuning and optimization on oracle\r- OEM, statspack, AWR experience needed\r- Experience of execution plans and how to use them to optimize/improve query costs and create new indexes\r- Understanding of RMAN, Data Guard \r- Experience with how oracle security works\r- Monitoring database performance during application performance testing and recommending database changes\r- Oracle export/import experience.\r- Experience backing up databases from one environment and restoring them in other database environments\r- PostgreSQL experience\r- Demonstrable experience with PostgreSQL Database design and development including creating stored procedures and functions \r- Thorough understanding of relational database design and concepts\r- Demonstrable experience of Installation, migration, upgrade and maintenance of multiple PostgreSQL Databases\r- Demonstrable experience with backups, recovery, performance tuning and optimization\r- Understanding execution plans and how to use them to optimize/improve query costs and create indexes
Other Criteria considered \rExperience in managing the databases in AWS cloud\r- Previous Client Experience is a plus\r- Experience in other financial organization is a plus- \r- Experience as Development DBA \r- Advanced Knowledge of Windows Server Administration, different disk technologies, disk replication, Networking etc.\r- Understanding of other Databases like Teradata, DB2, etc.\r- Familiarity with Tools / languages like Terraform, Ansible, Jenkins, python etc.\r- Familiarity with Web Applications.\r- Knowledge of any other programming languages, like .Net, Visual Basic, Java, C , C#, etc.\r
Website : http://www.iconma.com
ICONMA is a nationwide consulting firm with corporate headquarters in Troy, MI, providing Professional Staffing and Project Based Services and Solutions for Fortune 1000 clients in a broad range of industries. Core Industries served include: Biotech/Pharmaceutical, Cable, Clinical, Consumer Services, Energy, Engineering, Financial Services, Food & Beverage, Government/Defense, Healthcare, Insurance, Logistics, Manufacturing, Media, Mortgage, Oil & Gas, Pharmaceutical, Retail, Scientific, Services, Technology, Telecommunications, Transportation, and Utilities. ICONMA is a certified Woman-Owned “Woman-Owned Business Enterprise”, certified by Women’s Business Enterprise National Council (WBENC) and National Women Business Owners Corporation (NWBOC).