| Duties & Responsibilites : | QL Server DBA skills experience needed.
Basic Oracle database administration on the Unix environment as a secondary skill preferred.
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 - 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 as a development/application DBA needed
SQL Server experience - needed
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
Good knowledge and understanding of SQL Server database mirroring, replication, and log shipping
Extensive experience with Microsoft Windows Server 2003/2005/2008 operating system
Oracle DBA experience .
Creation of databases in HPUX / AIX environment
High level experience with writing Korn shell scripts
Understanding of how memory, CPU, Disks work on the UNIX environment
High level understanding of OEM, statspack, AWR
High level Understanding of RMAN, Data Guard and RAC
Good knowledge of how user security works on the oracle environment
Experience backing up databases from one environment and restoring them in other database environments
Other Criteria considered
Previous Financial Institution Experience is a plus
Experience in other financial organization is a plus
Experience with tools like controlm, Idera, HP-Service Manager, Clarity
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. |
