Ref No.: 19-01925
Location: Houston, Texas
Role Database - L3 ( MS SQL , ORACLE and Pervasive PSQL )

Role Description The DBA will perform administration and engineering for multiple production
databases, and will be responsible for fast-paced, complex distributed database
environments supporting both OLTP and OLAP systems across multiple
platforms. Candidate will be able to troubleshoot complex technical problems
under pressure, implement solutions that are massively scalable, while managing
multiple customer groups.
Migration and design knowledge of MS-SQL, Oracle Database concepts
Experience on Pervasive PSQL database

Technical expertise
areas – Primary Skill

¿ Migration of MS SQL and Oracle database at On premise and Public cloud
¿ Design and Build on SQL Server DB (multiple MS SQL 2008, 2012, 2014) and
Oracle Database 11g and 12C, Pervasive Database (v12)
¿ Experience in monitoring Knowledge of reporting and query tools
¿ Work experience on Backup and Restore
¿ Work experience on User management, Table space management,
Knowledge on Log shipping, Mirroring, HA and data replication
¿ Migration and data refresh activities
¿ Performance tuning of Database ,
¿ Creation of user and export import activity

Technical expertise
areas – Secondary
Skill

¿ Build VmWare Esx and RedHat Linux
¿ Backup

Key Responsibilities ¿ Experience in Solution design and Migration

¿ Provide written and verbal recommendations to vendor supplied
solutions including, but not limited to indexing, code modifications,
process improvements and logical and physical data structures.
¿ Provide technical assistance to developers, perform code reviews,
identify inefficient code, provide suggestions for rewriting queries to
ensure optimal execution
¿ Ensure backup and recoverability of all enterprise SQL server databases.
¿ People management and leadership skills.
Prior Experience Minimum of 8-12 years Database Administration

Experience with administering and supporting multiple MS SQL and Oracle
databases for performance critical, highly available systems on various and
supported OS platforms.
Excellent troubleshooting and problem-solving abilities.

Education ¿ Graduate with a BE/B. Tech degree preferred or Bachelor's degree in

Computer Science, Computer or Electrical Engineering,
¿ MS SQL and Oracle certified engineers

Attributes ¿ Positive attitude with encouragement nature of mentoring team