Major Roles & Responsibilities:
- Database Infrastructure Engineering for stability and scalability, capacity planning
- Application DBA functions: plan & execute database schema changes, bottlenecks analysis, outage prevention/resolution, server/database performance improvements, database maintenance, database recovery, etc.
- Database development (stored procedures, ETL, tools) and queries/stored procedures review and optimization
- Enforce database security, standards & guidelines

Skills Required:
- At least 5 years’experience in DB2 or Oracle and have exceptional hands-on application DBA skills.
- DB2 Linux version 10.5 and above (SQL, Temp tables, plan explains, MQTs, MDCs, referential integrity constraints, etc)
- The candidate must be familiar with some similar modeling tool
- The candidate must be familiar with scripting language such as Perl and Unix / K-Shell .
- The candidate must have strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts
- Personal skills: Integrity & ownership, good team player, ability to work under time and resource dependencies and constraints, ability to find simple and effective solutions, high degree of motivation to expand technical and business knowledge.

Skills Desired:
- Communications skills are important as the candidate will need to work with other internal/external developers who will be accessing the databases and have change requests.
- Knowledge of other relational databases, especially solid Sybase expertise is a plus
- Versioning tools such as perforce, etc.. is a nice to have - Knowledge of the transactional database requirements of multiple financial asset classes would be a great benefit

At Optimum Solutions, we are proud of being IT Partners of choice of several medium and large global organizations. Since our inception in 1997, we have grown by addressing the evolving needs of our customers and contributing our best towards their growth and success.

We are a rapidly growing provider of IT Solutions and Services offering a wide range of IT Services to meet our customers growing needs. We are focused on providing services around Enterprise Solutions, Custom solutions and Business Intelligence solutions. We help our customers implement these solutions through our skilled consulting services, implementation services, application management services and through infrastructure management services.

We deliver our services through a global delivery model using a blended team of onsite and offshore consultants depending on the needs of the customers and nature of the engagement.

Our customers are primarily from Banking and Finance, Manufacturing, Distribution, Technology, Service and Healthcare verticals.

Starting from a small customer-focused organization, Optimum has grown to a respectable mid-sized company in a short period of time. We take pride in successful execution of projects and achieving high levels of customer satisfaction. Our long standing customers are a testimony to the value we provide as an organization to our customers’ business and technology initiatives.

We are managed by a core team of professionals with tremendous experience working in a variety of consulting and business environment. We have developed into a rapidly growing, highly competitive and responsive firm with strong management, technical and financial resources and commitment to fully serve our clients.