SQL SERVER/ORACLE Database engineer (Mid-level)

THE OVERALL PURPOSE OF POSITION: • The purpose of this position is to perform and manage tasks related to the operation, support, administration, optimization, and maintenance of client-owned databases and database tools. SCOPE OF WORK The position's SCOPE OF WORK include the following: • Support of production and non-production databases: • Correct issues reported in production system • Support routine and ad-hoc IT DBA requests • Update documentation, if required as part of correcting production issues • Support implement SSIS packages and database objects like stored procedures, views, • functions, triggers, etc. • Implement and monitor daily and nightly database maintenance jobs • Monitor, diagnose, and respond to system failure and performance issues, taking appropriate measures to reduce system downtime and eliminate recurrence of the problem • Work with USAC technical staff, including network engineers and software developers, to analyze and improve system performance • Formulate and implement backup procedures for all company databases • Serve as technical support for any database related performance or access issue • Generate ad-hoc and routine reports and define metrics for database health and performance • Administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of company databases. • Perform or affect the performance of all database installations, patches, and planned upgrades. • Implement data models and database designs, data access and table maintenance codes. • Resolve database performance issues, database capacity issues, replication, and other database issues. • Perform database related development as dictated by departmental or project demands. • Design and perform data migrations and data transformations as required by application delivery teams or business customers. • Develop and maintain documentation, diagrams, and procedures and complies with company's change management control process. • Ensure that all database designs adhere to industry best practices. • Work with application delivery teams during database design. • Possess substantial knowledge about application and database performance profiles of all databases under their management. • Represent the IT department in terms of database expertise in coordination with other departments. QUALIFICATION AND EXPERIENCE: - Oracle • 4+ Years Oracle Database administration with Oracle 10g/11g, ASM • 4+ Years reviewing, writing, debugging, tuning PL/SQL & SQL code • 4+ Years Linux/Unix platforms and Linux Shell scripting • 4+ Years TOAD, Erwin, SQL Management Studio • 4+ Years database design and database development such as stored procedures, triggers, views, etc. • 3+ years oracle Dataguard (preferably Active Data Guard), Grid Control, RMAN 3+ Years • 3+ years experience with database characteristics such as table design, relationships, data partition, efficient indexes, storage allocation, capacity planning etc., • 3+ years display strong ability in troubleshooting complex issues • 3+ years experience in performance tuning and load testing of database • 3+ years knowledge of database security concepts NOTE: In addition, this is the desired experience. • Oracle 11g Certification • Demonstrated experience with Microsoft Reporting Services or other enterprise reporting tool. • Experience with clustered Oracle databases and high availability architectures. • SQL Server 2008 experience • Experience with agile software development such as SCRUM and XP • Experience with high availability database and application architectures QUALIFICATION AND EXPERIENCE: - SQL SERVER Experience • 4+ Years Database administration with SQL server 2005, 2008 R2. • 4+ Years SQL Server Management Studio, SQL Server Integration Services • 4+ Years Database design and development, triggers, views • 4+ Years Reviewing, writing, debugging, tuning SQL code • 3+ Years Developing of SQL scripts for stored procedures and functions • 3+ Years experience with physical database characteristics such as table design, relationships data partition, efficient indexes, storage allocation, capacity planning etc. • 3+ Years display strong ability in troubleshooting complex issues • 3+ Years experience in performance tuning and load testing of database • 3+ Years knowledge of database security concepts NOTE: In addition, this is the desired experience. • SQL Server Certification • Business Intelligence Development Studio 2005 / 2008R2 • SQL Server Reporting Services, SQL Server Analysis Services • Microsoft Visio, Erwin Data Modeling, TOAD • Idera SQL Server Diagnostic Manager. Idera SQL Safe. Idera SQL Doctor, Quest FogLight Oracle • Experience with high availability database and application architectures SPECIAL SKILLS: • Analytical and problem-solving skills • Developing and/or creating new or more effective ideas, approaches, etc. • Developing and executing short-range plans/decisions • Excellent interpersonal and communication skills • Ability to exercise sound judgment across a broad range of circumstances