Responsibilities

Database Administration:
  • Install, configure, and maintain MSSQL and Oracle database systems
  • Monitor database performance, ensure high availability, and implement necessary optimizations
  • Troubleshoot and resolve database-related issues in a timely manner
  • Perform regular backups, disaster recovery planning, and security management
  • Implement and enforce data integrity and security protocols

Database Programming:
  • Develop, optimize, and maintain database-driven applications using MSSQL and Oracle
  • Write and maintain SQL queries, stored procedures, triggers, and functions
  • Collaborate with software developers to integrate database functionality into applications
  • Ensure database code adheres to best practices and coding standards
  • Participate in database design and schema development

Performance Tuning and Optimization:
  • Identify and resolve performance bottlenecks in database systems
  • Optimize SQL queries and database objects for improved efficiency
  • Implement indexing strategies and query optimization techniques

Documentation and Reporting:
  • Maintain detailed documentation of database configurations, processes, and procedures
  • Generate reports on database performance and usage
  • Communicate database-related updates and issues to relevant stakeholders

Security and Compliance:
  • Implement and enforce database security policies and access controls
  • Ensure compliance with industry regulations and standards (e.g., GDPR, HIPAA)
  • Keep abreast of security threats and apply necessary patches and updates

Requirements

  • Bachelor’s Degree in computer science or related field with Minimum 8-10 years of experience in Microsoft SQL Server (2012 and above), Oracle Administration and/or Development
  • Proven experience as a database administrator and programmer with a focus on Oracle and preferred on MSSQL
  • Proficiency in SQL, T-SQL, PL/SQL, and scripting languages
  • Strong understanding of database design principles
  • Preferably with Certifications in MSSQL and Oracle database administration and Experience with cloud-based database services (e.g., AWS RDS, Azure SQL Database)
  • Good knowledge on Database architecture and design
  • Technical understanding of software builds and deployment together with relevant tools (i.e., PowerShell, Git, DevOps etc.)
  • Knowledge on infrastructure components (i.e., Virtualization, Network, Load Balancers, SAN), and commercial cloud AWS
  • Experience supporting a 24x7 high-availability production systems will be advantageous
  • Software development experience (any programming language) will be advantageous
  • Good analytical and critical thinking skills
  • Have service excellence attitude
  • Ability to work independently, as well as in a team with minimal supervision
  • Must have strong verbal and written communications skills to interact with team members and functional analysts on daily basis
  • Experience with database performance tuning and optimization
  • Knowledge of database security and compliance requirements
  • Excellent problem-solving and troubleshooting skills
  • Ability to work independently and collaboratively in a team
  • Effective communication and documentation skills
  • Familiarity with database migration and replication technologies
  • Knowledge of data warehousing concepts and tools
 
Shortlisted candidates will be offered 1 Year Agency contract employment.