Lead Consultant - Database Architect Job

Experience

10+ Years

Job Description

SQL/Oracle server administration experience. Good understanding on SQL Server - users,
permissions, roles, SPs, Triggers, Jobs, DB migration and recovery, SQL Reporting.
- Good performance tuning skills. You will help us make our database faster by running diagnostics
and doing query optimization and other performance tuning, and by designing indexing strategies.
- You should be able design databases and modify ,optimize and troubleshoot exiting databases.
- Ability to work in an agile environment, respond quickly to other business needs and resolve
production issue within timeliness.
- Knowledge in PowerShell and VB scripting required.
- Bachelor’s Degree in Computer Science, Computer Engineering or related discipline
- 7+ years of database (SQL server and Oracle) development experience
- Certified SQL/Oracle developer
- Basic working experience on Oracle databases e.g. Oracle 12c, Oracle 11g, Oracle 9i

Required Technical/ Functional Competencies

Oracle 12c and 19c DBA
Oracle Installation
Writing SQL complex queries,
Writing complex Stored Procedures , Packages, Functions
Debugging complex Stored Procedures , Packages, Functions, and other database objects. 
Performance tunning 
Helping to Other developers if they stuck in any SQL query writing. 
Shell Scripting 

PostgreSQL DBA
PostgreSQL Installation
Writing SQL complex queries,
Oracle to PostgreSQL migration 
Performance tunning 
Shell Scripting 

Required Behavioral Competencies

Accountability: Takes responsibility for and ensures accuracy of results and deadlines of the function and/or team and in completing own work.

Collaboration: Reaches out to others in team to ensure connections are made and team members are working together.

Agility: Looks for ways to integrate work with other teams, identifying similarities and opportunities, making necessary changes in work to ensure successful integration.

Customer Focus: Identifies trends and patterns emerging from customer preferences and works towards customizing/ refining existing services to exceed customer needs and expectations.

Communication: Communicates well-organized ideas, information, and data to broad and diverse audiences across the Organization (through formal and informal presentations).

Drives Results: Sets realistic stretch goals for self & others and perseveres to follow through with resilience and remains calm in a crisis or stressful situation to exceed organization/client expectation.

Resolves Conflict: Identifies and understands the source of conflict, addresses, and overcomes.

Certifications

Mandatory: OCE /Microsoft Certified Professional in SQL Server,Microsoft Certified Azure Database Administrator; Microsoft Certified Solutions Architect; Microsoft Certified Azure DevOps Engineer/ Biztalk and Azure Certification,CISSP, SDN Certification/ Citrix Virtual Apps and CC-VAD-CC, Professional Certifications in at least two Storage/ Backup Technologies Desirable: OCS, AWS CSA