VAM SYSTEMS is a Business Consulting, IT Solutions and Services company with operations in UAE, Qatar, Bahrain, USA, Australia, Singapore & India.
VAM SYSTEMS is currently looking for Database Administrator & Data Modular for our Bahrain operations with the following skill set and terms and conditions:
Skillset Required:
• Should have more than 7 years of work experience with a strong understanding of various databases
• Hands on experience in developing Database architectures, in a fairly large environment in the following areas:
• Strong understanding of database design and development practices and procedures.
• Strong domain knowledge of Data Warehousing and a demonstrated experience in database design for such environments of 3+ years.
• 4+ years of DBA experience on PostgreSQL platform with proved experience in database design, development, administration, and architecture.
• Proven experience installing PostgreSQL, creating databases, performance tuning, and managing users and security.
• Proven experience installing, performance tuning, and system monitoring and managing PostgreSQL and at least one other relational database product like DB2, MySQL, MS SQL, Oracle etc. (preferably MySQL or DB2)
• Understanding, and working knowledge in various database areas like data modelling, data warehousing, data migration etc.
• Hands-on experience with installations, upgrades, configuration, tuning, index creation and performance analysis in a PostgreSQL OLAP environment.
• Proven experience with PostgreSQL databases
• Strong understanding of advanced SQL queries (loops, exceptions, declares), table views, constraints, stored procedures and the impact of executing on the database.
• Ability to write SQL procedures, packages, functions and to advise ETL developers on best practices dealing with the data access layer.
• Heavy SQL experience writing complicated queries from scratch, tuning other’s code, analysing impacts.
• Experience implementing backup and recovery strategies with expertise in backup/recovery/fail-over methods and best practices.
• Hands-on experience installing and implementing both packaged and custom real-time monitoring and alerting solutions.
• Hands-on experience with automation of tools, implementations, scripting and database reporting metrics and reports.
• Familiarity with database administration tools.
• Strong analytical skills.
• Excellent communications skills both written and verbal.
Responsibilities:
• Provide strategic data architecture direction in projects and enterprise architecture;
• Establish the metadata standards for organizational reporting framework.
• Develop synergies across databases of Business Intelligence / Data Warehousing / OLAP and their respective applications.
• Leads development/adaptation of data architecture methodologies, standards and best practices, and selection of tools.
• Leads the development of enterprise data models and the addition or revision of data architecture artifacts.
• Manages the process of designing, developing and implementing data architecture.
• Liaises and participates in the governance of the data and data architecture artifacts.
• Responsible for the entire database administration related activities, including but not limited to monitoring, backup and recovery, security, performance management, and database object maintenance.
• Create physical database designs, conduct design reviews, perform backup and recovery and performance tuning
• Review, evaluate, design and implement strategies for data acquisitions from various formats into specifics databases (PostgreSQL) as required.
• Troubleshoot problems and work effectively with other team members to identify and address problems.
• Implement and maintain policies, procedures and standards to ensure security and integrity of test and production data.
• Perform in a fast-paced environment where project deadlines are critical and multiple projects may run in parallel.
• May act as client point-of-contact and expert on PostgreSQL database administration on projects.
• Report to project head frequently.
Education
• Bachelor’s degree in computer science/IT
• PostgreSQL Administrator Certification.
Terms and conditions:
Joining time frame: 2 weeks (Maximum 1 Month).
The selected candidates shall join VAMSYSTEMS- Bahrain and shall be deputed to one of the leading Organizations in Bahrain.
Should you be interested in this opportunity, please send your latest resume in MS Word format at the earliest at or call us +914762684924.