Donan Consulting
SQL SERVER/ORACLE Database engineer (Mid-level)
Donan Consulting, Washington, District of Columbia, us, 20022
Overview
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.
Scope of Work 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.
Qualifications 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 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
Qualifications and Experience - SQL Server
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
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
#J-18808-Ljbffr
Scope of Work 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.
Qualifications 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 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
Qualifications and Experience - SQL Server
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
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
#J-18808-Ljbffr