| Duties & Responsibilites : | Oracle database administration on the Unix environment skills needed.
SQL Server DBA
Communication skills and general DBA experience
-Highly motivated, job engaged, Team player
-Good verbal and written communication skills, able to clearly articulate complex technical issues and relate to development requirements and needs.
-Should be able to work across physical boundaries through phone, IM efficiently as rest of the database team is located in Richmond, VA
-Physical modeling experience needed - preferably in Erwin modeling tool
-Batch Jobs scheduling experience - controlm tool
-Candidates should have experience in large-scale environments
-Hands on experience with Microsoft Windows XP or higher version, Office, PowerPoint, Access, Visio and Project
-Strong change management experience for implementing database changes
-Experience promoting database objects from one environment to other and maintaining change logs
-Oracle DBA experience - Needed
-Previous financial Institution experience
-Creation of databases in HPUX / AIX environment
-High level experience with writing Korn shell scripts
-Very good understanding of how memory, CPU, Disks work on the UNIX environment
-Demonstrate experience with backups, recovery, performance tuning and optimization on oracle
-OEM, statspack, AWR experience needed
-Experience of execution plans and how to use them to optimize/improve query costs and create new indexes
-Understanding of RMAN, Data Guard
-Experience with how oracle security works
-Monitoring database performance during application performance testing and recommending database changes
-Oracle export/import experience.
-Experience backing up databases from one environment and restoring them in other database environments
-Experience with upgrading oracle databases from oracle 10g to 11g
SQL Server experience
-Demonstrable experience with SQL Server Database design and development including creating stored procedures and functions using T-SQL
-Thorough understanding of relational database design and concepts
-Demonstrable experience of Installation, migration, upgrade and maintenance of multiple SQL Server Databases
-Demonstrable experience with backups, recovery, performance tuning and optimization
-Understanding and some working knowledge of SSIS/DTS, SSAS, SSRS and common ETL practices
-Understanding execution plans and how to use them to optimize/improve query costs and create indexes
-High level understanding of SQL Server database mirroring, replication, and log shipping
-Strong working knowledge of the Microsoft Windows Server 2003/2005/2008 operating system
Other Criteria considered
-Experience with tools like controlm, Idera, HP-Service Manager, Clarity
-Experience as Development DBA
-Advanced Knowledge of Windows Server Administration, different disk technologies, disk replication, Networking etc.
-Understanding of other Databases like TeraData, DB2, etc.
-Familiarity with ETL Tools like AbInitio, DataStage, Informatica, etc.
-Familiarity with Web Applications.
-Knowledge of any other programming languages, like .Net, Visual Basic, Java, C++, C#,etc. |
