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:
Job Title: Database Administrator & Data Modular for Bahrain
Location: Bahrain
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.
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.
Terms and Conditions:
- Joining time frame: 2 weeks (Maximum 1 Month).
Application Closing Date
31st December, 2013.
How to Apply
Interested and qualified candidates should send your latest resume in MS Word format at the earliest at:
[email protected] or call +91 476 2681150.
The selected candidates shall join VAMSYSTEMS- Bahrain and shall be deputed to one of the leading Organizations in Bahrain.