Job Description
Core Edge Solution is currently recruiting a Senior Database Developer to work onsite in our Gulberg 3, Lahore Office, The Senior Database Developer is responsible for leading and coordinating all database activities, managing and securing SQL instances and databases, and developing complex queries, scripts, and functions to advance the company's objectives. The ideal candidate will have extensive experience with SQL Server, and experience with Snowflake and AWS is a major plus.
This is a full-time on-site role for a Senior Database Developer. Working hours are from 05:00 pm to 02:00 am. Candidates must be able to commute to Gulberg 3.
Essential Duties and Responsibilities:
- Lead the design, development, and implementation of database systems based on requirements.
- Create complex queries, functions, scripts, stored procedures, and triggers to support application development.
- Import and extract files in .csv or .xlsx formats to and from databases.
- Draft design specifications and functional documentation for assigned database projects.
- Develop and enforce security procedures to protect databases from unauthorized access.
- Optimize database systems for performance efficiency.
- Identify and resolve issues related to database performance.
- Test databases and perform bug fixes.
- Troubleshoot database-related issues in a timely fashion.
- Mentor and guide junior database developers, fostering a collaborative team environment.
Required Skill Sets:
- Minimum of 5 years of experience in developing and managing database projects using SQL Server 2012 and up.
- Proficiency with SQL Server Management Studio (SSMS).
- Extensive experience with SQL Server Integration Services (SSIS) for ETL processes.
- Hands-on experience with Snowflake and AWS databases.
- Hands-on experience with MS Office applications.
- Advanced skills in Data Modeling, Database design, and SQL Server best practices.
- Expertise in Query Tuning, Database Tuning, Performance tuning, and various indexing methods.
- Excellent verbal and non-verbal communication skills.
- Strong decision-making and problem-solving capabilities.
- Demonstrated ability to lead and work effectively as part of a team.