Posted Feb 15, 2020 3 views
The Database Base Administrator position will be responsible for maintaining the company’s database including back-up, stored procedures, performance tuning, capacity planning, monitoring critical events and documentation.
Key Areas of Responsibility:
- Create and manage multiple databases and assist in capacity planning
- Monitor, maintain database systems and troubleshoot problems that may arise
- Maintain data integrity and security (manage roles and permissions of database users)
- Use tools of Oracle & SQL Profiler for database tuning.
- Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them
- Develop strategies and implement solutions for managing back-ups, restoration and replication
- Create and manage constraints and indexes
- Support software developers with database operations including the development of Oracle DB, complex SQL, tuning of DML, creation of stored procedures, and migrating changes from dev to higher environments
- Proactive housekeeping/archiving and shrinking of databases
- Manage production, QA and development database environments
- Create detailed documentation including diagrams of database infrastructure
- Learn relevant business processes and understand the data flow, criticality and dependencies
- Effectively coordinate and communicate with all the stakeholders (internal teams)
- Set up and maintain database infrastructure for the company’s BI needs
Requirements / Qualifications:
- Extensive experience writing in Oracle, MSSQL, T-SQL and stored procedures and query tuning on high transaction systems
- Experience in Oracle, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) will be a plus
- Experienced in ETL (Extract-Transform-Load) development / data integration
- Sound knowledge of RDBMS concepts, database architecture, Oracle and SQL/T-SQL
- Proficient with RDMBS profiler for monitoring and troubleshooting database activity and performance
- Hands-on experience in setting up, monitoring, and managing
- Knowledge of other databases like No SQL, Oracle databases and In-memory databases and MCTIP certification will be an advantage.
- Ability to develop procedure documents and maintain detailed database related documents
- An innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies
Education: Bachelors or Master’s degree in computer science
Specific Tasks
- Writing in Oracle, MSSQL, T-SQL
- ETL (Extract-Transform-Load)
- RDBMS concepts, database architecture
Skills
Job Details
Gourmet Pakistan
Gourmet Pakistan was founded in 1987 by Muhammad Nawaz Chatta. The company is headquartered in Lahore, Pakistan, and produces a wide range of food products, including bakery items, sweets, carbonated soft drinks, beverages, and many more. The company operates through various subsidiaries, including Gourmet Foods, ANC Foods, Five Star Foods, GNN, QuinTech Group, and Rasool Nawaz Sugar Mill, and has a presence in over 12 cities across Pakistan.
What is your Competitive Advantage?
Similar Job Titles
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Muzammil Baig
Digital Marketing Manager
IT Services Group
Aqib Irshad
Head of HR, Training & OD
FINCA
Zohaib Ali
Marketing Manager
Digital Online Devices
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Ali Aziz
CEO
Shopistan
