SQL SERVER/ORACLE Database engineer (Mid-level)- job post
Job Description
Washington,
Full job description
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
