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