Posted Apr 23, 2019
The purpose of this position is to perform SQL Development functions including: design new or enhance existing enterprise database systems, maintain or develop critical databases processes, perform unit and system testing, provide technical support to Support Team. The position is responsible for creating SSRS reports by collaborating with management team.
ESSENTIAL JOB FUNCTIONS:
- Program in T-SQL with relational databases including currently supported versions of Microsoft SQL Server
- Write SQL queries using Joins, Cross Apply, Aggregate Queries, Merge, Pivot
- Develop and maintain Stored Procedures, Functions and Views
- Design normalized database tables with proper indexing and constraints
- Perform SQL query tuning and performance optimization on complex inefficient queries
- Use table variable, temporary table, CTE appropriately to deal with large datasets
- Analyze queries for any deadlock resulting due to conflicts
- Collaborate with DBA on database design and performance enhancements
- Participate in all phases of the software development life cycle in a team environment
- Debug existing code and troubleshoot for issues
- Develop and maintain database processes such as code restrictions and business rules, Agent Jobs, letter and automated call logic
- Translate business requirements into report designs by collaborating with management
- Create reports in tabular, matrix, chart, and free-form report layouts
- Develop data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching
- Keep up-to-date with the latest database features, techniques, and technologies
- Support current business applications including the implementation of bug fixes as needed
- Able to multi-task and adapt to shifting priorities
- Able to meet deadlines set in project planning
- Communicate progress through the project execution phase
- Follow industry and company standard coding practices
- Test database process feature enhancements and bug fixes
- Produce quality deliverables upon deployment
- Assist support analysts with issues they are unable to resolve
- Ensure customer satisfaction by meeting customer needs in a courteous and timely manner
QUALIFICATIONS:
- Minimum 4 years of work related experience in T-SQL database development. If candidate has relevant education in computer science, computer information systems, or related field, lack of experience can be supplemented by education as follows:
- Microsoft Certifications – 1 year
- Associate’s Degree – 1 year
- Bachelor’s Degree – 2 years
- Master’s Degree – 3 years
- Experience in developing, maintaining and supporting database processes using Microsoft SQL Server with emphasis on .NET technologies.
- Proficient with one or more of the following; T-SQL, SSRS, SSIS, SSAS, Data warehousing, ETL will be a Plus.
- Demonstrated ability to perform above listed essential job functions.
Job Details
Aekpani Networks
Aekpani Networks, has been providing top-quality service at affordable prices to a diverse customers base. We work to fit each of our customers individual needs by talking with them personally, and using their feedback learns how to improve out service even more. Every company is built on its clients, and we strive to make it know to every one and every one of our clients that they are the ones who truly make Aekpani Networks, what it is, and represent what it can be.
What is your Competitive Advantage?
Similar Job Titles
Muzammil Baig
Digital Marketing Manager
IT Services Group
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Zohaib Ali
Marketing Manager
Digital Online Devices
Aqib Irshad
Head of HR, Training & OD
FINCA
Ali Aziz
CEO
Shopistan
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Mona Sharif
Senior Team Lead
Konext PVT. LTD
