SQL SERVER​/ORACLE Database engineer; Mid-level

The overall 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.

The position’s scope of work includes 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

NOTE:
In addition, this is the desired experience.

• 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 Data Guard (preferably Active Data Guard), Grid Control, RMAN
• 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

• 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 Fog Light
• Experience with high availability database and application architectures

• 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