Reporting to: Applications & Systems Manager
Position Summary This is primarily a MS SQL Server Database Administrator role responsible for providing operational database services. This is largely a production Database Administrator role, and will include responding to database related alerts and escalations, reviewing service related reports on a daily basis to ensure issues are identified and resolved within established SLAs and proactively escalating any issues that cannot be resolved within the established timeframes. The role will require initiating, coordinating and performing changes on production systems by adhering to the defined change control process and, from time to time, will require you to assist with a few TSQL queries to help assist application teams, managers and customers with information they are looking for.
Responsibilities
- Ensure availability of MS SQL Server databases and related services. In case of failures, troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
- Ensure successful completion of database backups
- Ensure successful completion of SQL server agent jobs, both, related to application (example: ETL jobs), database maintenance jobs (example: integrity checks, index and statistics updates). In case of failures, troubleshoot failed SQL Server Agent jobs
- Monitor and troubleshoot SQL server transactional replication, service broker, file stream
- Monitor and troubleshoot SQL Server Always on availability groups and failover clustered instances
- Monitor and troubleshoot SSIS packages
- Install, perform upgrades and configure SQL servers – including integration services, reporting service and analysis services
- Manage and troubleshoot access to SQL server databases
- Review/audit overall system security and data integrity
- Trace queries taking longer to complete and provide necessary inputs for tuning those T-SQL queries to improve performance
- Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues and security issues
- Develop queries to help assist application teams, managers and customers with ad hoc reports
- Participate in change control activities, review and deploy database change scripts provided by vendors
- Take part in database administrator team on-call rotation
Education / Certification Requirements:
- Bachelor’s degree
- MCTS, MCITP in any of the following SQL Server 2005 / 2008 R2 / 2012
Skills and Experience
- At least 5 years of experience in MS SQL Server database administration – covering MS SQL Server 2005, 2008 R2 and 2012
- Experience installing, patching, configuring, securing, maintaining, monitoring and troubleshooting MS SQL server in both stand-alone and clustered environments
- Experience installing, configuring and managing MS SQL server reporting services, analysis services and integration services
- Knowledgeable in MS SQL server recommendations and best practices
- Experience supporting very large databases, sizes ranging from a few gigabytes to multi-terabytes
- Experience in troubleshooting and resolving database problems
- Experience managing and troubleshooting table partitioning
- Experience managing and troubleshooting service broker
- Experience managing and troubleshooting file stream
- Experience with backups, restores and recovery models
- Experience with SQL Server database maintenance procedures, with a good understanding of indexes, index management, and statistics
- Experience in capacity planning and performance monitoring for resource utilization and bottle-necks, performance tuning and optimization of TSQL workload
- Experience of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server covering and not limited to always on availability groups, transactional replication, failover clustered instances, SAN replication
- Knowledge of MS SQL server DMV’s and KPI’s and relevant experience in automating MS SQL Server monitoring and base lining using scripts
- Exposure to Oracle database administration, virtualization technologies and SAN storage essentials for a DBA will be a plus
- Knowledgeable in ITIL framework and relevant experience in incident, problem, change and service request management
Personal competencies
- Capability to work with multinational cultures
- Ability to work in a team and share best practices
- Ability to take responsibility of problem solving
- Proven ability to perform independent thought process and workings will be required
- High energy
- Driven for success
- Being able to articulate at a high/detailed level to peers/managers
- Solution orientated used in fast track environments
JOB DESCRIPTION:
Database Administrators (DBA) use database software to store and manage information. DBA will often set up database systems and are responsible for making sure those systems operate efficiently (usually referred to as database performance tuning). They also make sure that the data they store is backed up regularly, stored effectively, and that the data is secure from unauthorized access. Ensuring the data is available, by maximizing database uptime.
SCOPE OF THE WORK:
The DBA has the following functions like:
- Maintain prod & test instances
- Purge logs & trace files regularly
- Apply patches
- Pruning, purging and archiving the old dated data.
- Manage & maintain profiles.
- Manage & maintain responsibilities
- Manage Mid-tier components
- Tune Mid-tier components…
- Set up data sharing and disk partitioning
- Develop database utilities and automated reporting
- Create shell scripts for task automation
- Implement load balancing and fail over capabilities
- Analyze and sustain capacity and performance requirements
- Analyze, consolidate and tune database for optimal efficiency
- Monitor systems and platforms for availability.
- Oversee backup, clustering, mirroring, replication and failover
- Install upgrades and patches for DB and IAS.
- Implement security and encryption
- Provide best approach to consolidate for oracle license (recommendation for standard and enterprise)
- Evaluate and recommend new database technologies
- Onsite with 24*7 Coverage for Severity One issues
- Performance Tuning of database parameters after review of software configuration and Recommendations for infrastructure enhancement
Experience:
- Minimum 4 years’ experience as a Database Administrator in MS SQL\Oracle.
- Knowledge of business functions and Team player & possess good judgment skills
- Monitor and optimize system performance (health check) experience.
- Mirroring and HA experience.
- Certification on MS SQL 2008/2012 and Oracle 10/11i will be plus.
Deliverables:
Here are the ten deliverables of the database administration role
A database that meets the needs of the business: The needs of the business include certain levels of performance, security, and availability.
A secure document library: that should be retained include service level agreements, network diagrams, architecture diagrams, licensing information, E-R diagrams, performance reports, audit reports, software manuals, installation notes, project notes, copies of important correspondence, and so on.
Work logs of service requests, alarms, and changes: how work logs help bring about improvements and efficiencies in your ability to provide good service to the business.
Standard Operating Procedures: Any database administration task that is done repeatedly should be codified into a Standard Operating Procedure (SOP). Using a written SOP helps efficiency and accuracy.
Procedures and records for backup testing and failover testing: It is absolutely essential that backup procedures and disaster recovery procedures be documented. The procedures should be periodically tested and records should be maintained.
Maintenance and batch schedules, documentation, and records: Database maintenance procedures should be documented and records should be maintained.
Database administration tools: Database administration tools include MS SQL, Oracle-supplied tools such as Database Control, Grid Control, and SQL Developer. The Management Packs, such as Diagnostics Pack, Tuning Pack, Change Management Pack, and Configuration Pack, are very valuable tools
Management reports: database reports for management are reports on database growth, workload, and performance. STATSPACK and AWR histories should be retained for as long as practicable.
Audit reports: refers to audit reports conducted by security auditors but can also refer to internal audits of compliance with organizational processes such as Change Management or database reviews by external consultants.
Our client a leading provider of services in the maritime logistics sector with a global service and organisation is looking to hire a switched on individual into their logistics team here in the UAE.
Main Responsibilities:
•Monitoring, Benchmarking and Negotiation of rates with Administration Suppliers (Courier, Printing, Stationery)
•Front Office personnel in UAE offices (5 persons) reporting to Admin Co-ordinator & One Senior Office Assistant
•Co-ordinate Lease Vehicle Contracts
•Attending to and assisting with maintenance requests/complaints from WSS UAE Offices.
•Arrange and co-ordinate purchase of Office Equipment – Telephone, Photocopier, Telefax, Furniture, etc) and carry out periodic checks on office photocopiers, telefax machines, typewriters, refilling of cartridges, ensuring copiers have paper and all equipment is working properly.
•Issuance of Weekly Management Travel Plan.
•Maintenance of the Administration Database (DEWA, Petrol Cards, Salik Cards, Printing, Stationery, Annual Maintenance Contracts etc).
•Verification, Coding and Allocation of Administration Invoices/Expenses.
•Purchasing & Maintaining records of Office Provisions (Tea/Coffee/Milk Powder/sugar/soft Drinks, etc.) for all Dubai branch offices.
•Handling new, renewal and disconnection of all communication requirements for WSS Offices and Sponsored Companies.
•Liaison with Etisalat for complaints and trouble shooting and follow up with WSS Offices, Management and Sponsored Companies.
•Liaison with Government and Local Departments and Offices (DEWA, EPPCO, EMARAT) for applications (new, renewal, cancellation) and complaints.
•Prepare and Participate in Internal Audit (Admin), provide feedback on Audit Report. Arrange Annual Performance Appraisal of Administration Suppliers. Follow up and complete proposed corrective actions, Improvement Potentials etc.
•Ensuring all offices are kept in a tidy and clean manner.
•Overseeing office suppliers (Cleaning, Hygiene Products, Air conditioning, Maintenance etc) and ensuring their satisfactory performance.
•Co-ordinating various requirements for Main and Branch Offices and Sponsored Companies.
•Overall responsible for the Administration Database.
• Provide assistance and handle ad-hoc responsibilities delegated by the Manager – Admin & Human Resources.
Required Experience/Skills:
•Excellent English communication skills - written & verbal.
•Minimum 2 years experience in relevant field.
•Knowledge of Logistics and Marine logistics an asset.
Should your application for the position of HR/Admin - Logistics - Dubai be successful, you will be contacted within 72 hours.
Failure in selection for this position will not affect applications for other positions we currently have advertised.
As specialists in the Freight Forwarding, Shipping, Aviation, Logistics, Relocations and Courier industries, we are always looking for exceptional / highly experienced candidates. If you feel you have the necessary experience in any of the above sectors, please forward your C.V. and we will be happy to assist you in finding a new position
Administrative Assistant-Executive Office - 14001OFM
Job : Administration Primary Location : QAT-Qatar-Doha-The Ritz-Carlton, Doha Organization : Ritz-Carlton Position Type : Non-Management/Hourly Schedule : Full-time
At more than 80 award-winning properties worldwide, The Ritz-Carlton Ladies and Gentlemen create experiences so exceptional that long after a guest stays with us, the experience stays with them. As the premier worldwide provider of luxury experiences, we set the standard for rare and special luxury service the world over. We invite you to explore The Ritz-Carlton.
Job Summary Enter and retrieve information contained in computer databases using a keyboard, mouse, or trackball to update records, files, reservations, and answer inquiries from guests. Transmit information or documents using a computer, mail, or facsimile machine. Operate standard office equipment other than computers. Prepare letters, memos, and other documents using word processing, spreadsheet, database, or presentation software. Handle incoming and outgoing mail, including date stamping and distributing incoming mail. Create and maintain computer- and paper-based filing and organization systems for records, reports, documents, etc. Compile, copy, sort, and file records of office activities, business transactions, and other activities. Enter and locate work-related information using computers and/or point of sale systems. Follow all company policies and procedures, ensure uniform and personal appearance are clean and professional, maintain confidentiality of proprietary information, and protect company assets. Welcome and acknowledge all guests according to company standards, anticipate and address guests' service needs, assist individuals with disabilities, and thank guests with genuine appreciation. Speak with others using clear and professional language, prepare and review written documents accurately and completely, and answer telephones using appropriate etiquette. Develop and maintain positive working relationships with others, support team to reach common goals, and listen and respond appropriately to the concerns of other employees. Move, lift, carry, push, pull, and place objects weighing less than or equal to 10 pounds without assistance. Perform other reasonable job duties as requested by Supervisors. The Ritz-Carlton is an equal opportunity employer committed to hiring a diverse workforce and sustaining an inclusive culture. The Ritz-Carlton does not discriminate on the basis of disability, veteran status or any other basis protected under federal, state or local laws.
This is primarily a MS SQL Server DBA role responsible for providing operational database services. This is largely a production DBA role, and will include responding to database related alerts and escalations, reviewing service related reports on a daily basis to ensure issues are identified and resolved within established SLAs and proactively escalating any issues that cannot be resolved within the established timeframes. The role will require initiating, coordinating and performing changes on production systems by adhering to the defined change control process and, from time to time, will require you to churn a few TSQL queries to help assist application teams, managers and customers with information they are looking for.
- Ensure availability of MS SQL Server databases and related services. In case of failures, troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
- Ensure successful completion of database backups.
- Ensure successful completion of SQL Server Agent jobs, both, related to application (example: ETL jobs), database maintenance jobs (example: integrity checks, index and statistics updates). In case of failures, troubleshoot failed SQL Server Agent jobs.
- Monitor and troubleshoot SQL Server transactional replication, Service Broker, File Stream.
- Monitor and troubleshoot SQL Server Always on Availability groups and Failover Clustered Instances.
- Monitor and troubleshoot SSIS packages.
- Install, perform upgrades and configure SQL Servers including Integration services, reporting service and analysis services.
- Manage and troubleshoot access to SQL Server databases.
- Review/audit overall system security and data integrity
- Trace queries taking longer to complete and provide necessary inputs for tuning those T-SQL queries to improve performance.
- Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues and security issues.
- Develop queries to help assist application teams, managers and customers with ad hoc reports.
- Participate in change control activities, review and deploy database change scripts provided by vendors.
- Take part in DBA team on-call rotation.
Requirements - Bachelors degree
- MCTS, MCITP in any of the following SQL Server 2005 / 2008 R2 / 2012
- At least 5 years of experience in MS SQL Server database administration covering MS SQL Server 2005, 2008 R2 and 2012.
- Experience installing, patching, configuring, securing, maintaining, monitoring and troubleshooting MS SQL Server in both stand-alone and clustered environments.
- Experience installing, configuring and managing MS SQL Server Reporting services, Analysis services and Integration services.
- Knowledgeable in MS SQL Server recommendations and best practices.
- Experience supporting very large databases, sizes ranging from a few gigabytes to multi-terabytes.
- Experience in troubleshooting and resolving database problems.
- Experience managing and troubleshooting table partitioning
- Experience managing and troubleshooting service broker.
- Experience managing and troubleshooting file stream.
- Experience with backups, restores and recovery models.
- Experience with SQL Server database maintenance procedures, with a good understanding of indexes, index management, and statistics.
- Experience in capacity planning and performance monitoring for resource utilization and bottle-necks, performance tuning and optimization of TSQL workload.
- Experience of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server covering and not limited to Always on Availability Groups, transactional replication, Failover Clustered Instances, SAN Replication.
- Knowledge of MS SQL Server DMVs and KPIs and relevant experience in automating MS SQL Server monitoring and base lining using scripts.
- Exposure to Oracle database administration, virtualization technologies and SAN storage essentials for a DBA will be a plus.
- Knowledgeable in ITIL framework and relevant experience in incident, problem, change and service request management.
Duties and Responsibilities:
1.Oversee implementation and proper application of office activities, business transactions, policies and board resolutions
2.Manage the maintenance of current database of relevant information
3.Oversee corporate events coordination
4.Prepare and review operational reports and schedules to ensure accuracy and efficiency.
5.Ensure proper renewal and follow up on
a.Lease Agreements and Contracts for Shops/Offices/Warehouses
b.Rent payment/collection for Shops/Offices/Warehouses
c.Customer / Supplier contract
6.Manage processes to ensure facilities safety and security, housekeeping, parking and recreational facilities management, and all functional areas
7.Plan, administer and control budgets for contracts, equipment and supplies.
8.Oversee the maintenance and repair of machinery, equipment, and electrical and mechanical systems.
Qualifications and Experiences:
1.Minimum, a Bachelor degree in Business Administration or any equivalent major.
2.7 to 10 years work experience in the field of the administrative work. Preferably within a construction or engineering industry.
3.Proficiency in English and Arabic is a must.
4.The use of computer programs related to his field of work.
Duties and Responsibilities:
1.Oversee implementation and proper application of office activities, business transactions, policies and board resolutions
2.Manage the maintenance of current database of relevant information
3.Oversee corporate events coordination
4.Prepare and review operational reports and schedules to ensure accuracy and efficiency.
5.Ensure proper renewal and follow up on
a.Lease Agreements and Contracts for Shops/Offices/Warehouses
b.Rent payment/collection for Shops/Offices/Warehouses
c.Customer / Supplier contract
6.Manage processes to ensure facilities safety and security, housekeeping, parking and recreational facilities management, and all functional areas
7.Plan, administer and control budgets for contracts, equipment and supplies.
8.Oversee the maintenance and repair of machinery, equipment, and electrical and mechanical systems.
Qualifications and Experiences:
1.Minimum, a Bachelor degree in Business Administration or any equivalent major.
2.7 to 10 years work experience in the field of the administrative work. Preferably within a construction or engineering industry.
3.Proficiency in English and Arabic is a must.
4.The use of computer programs related to his field of work. |
|
|
|
|
|
|
No comments:
Post a Comment