Sql Server Database Developer

Iris Jeet Singh Kaleka

*** ********* *****, ******* ****, CA 91320 · 916-***-**** · ***********@*******.***

Professional Summary:

25+ years of experience in the design, prototype, development and implementation of complex software systems.

Microsoft Certified Database Administrator, Microsoft Certified Solution Developer ( .Net )

Proficient in Internet/Intranet and Client-Server technologies and area of expertise includes ASP, IIS, VB, COM+, ADO, ODBC, HTML, JavaScript, SQL Server.

Diverse technical knowledge of Requirement Analysis, Object Oriented Design and Architecture, Programming and Distributed Computing.

Well versed in drafting software specifications and gathering user requirements

International work experience with reputed clients in Germany, US and Asia.

SQL Server

SQL Server 2019, 2014, 2008, 2005, 2000 and 7.0. SQL Server Instance version upgrades, Snapshot, Merge and Transactional replication, SQL Server interactions with application and web servers, Disaster Recovery, Backup and Restore, Backup Devices, Stored Procedures, Views, DTS Packages, Maintenance plans, SQL Jobs, Triggers, ODBC, T-SQL Programming, ETL, Reporting Services

Web Technologies

ASP, COM+, HTML, DHTML, XML, IIS, ASP.Net, C#, JQuery

Methodologies

Experienced in software engineering

Operating Systems

Windows 2003 Server, Windows 2000 Server, Windows NT, Windows XP

Certifications

Microsoft Certified Database Administrator, Microsoft Certified Solution Developer ( .Net )

Education

Masters Degree in Computer Science, Thapar Institute of Engineering, India

Bachelors Degree in Mathematics, Panjab University, India

Work Experience:

Staff Database Engineer

Blackline Systems Inc, Woodland Hills,, CA Aug 2012 – Mar 2025

Worked on client databases for a Software as a Service company.

Designed and developed database routines and objects for Products offered by the company, ensuring performance and backward compatibility with existing products.

Performance Optimization of SQL Server objects e.g. Stored Procedures and Views to ensure acceptable client response times.

Designing and developing new routines and objects to fulfill new client requirements.

Worked with SSIS, SSRS and Powershell

Worked on a data warehouse project, during my tenure at Blackline

Was involved in Data Archiving.

Training in Python, PostgreSQL.

ENVIRONMENT: SQL Server, SSRS, SSIS, Powershell, Python, PostgreSQL

SQL DBA / SQL Developer

J.D. Power and Associates, Westlake Village, CA Feb 2006 – July 2012

Designed and developed the database for Products, ensuring backward compatibility with existing products.

Engineered replication process and schedules for reporting and stand-by node purposes. This includes, snapshot, transactional, and merge replication. This included replication to SQL Servers in the Amazon cloud

Reduced daily data load times from 20+ hours to 3 hours.

Optimized query execution by automating missing index analysis and creation

Designing and developing new routines and objects to fulfill client requirements.

Design & Development of Web Applications Using ASP, XML, HTML/DHTML, JavaScript (client and Server based), VBSCRIPT, SQL Server

Design & Development of a B2B Reporting Site as well as a BI Dashboard and Analytical tool using .Net ( C# ) HTML/DHTML, JavaScript (client and Server based), Jquery, SQL Server

Providing technical solutions for business issues.

Providing resolution for issues raised by clients or the Quality Assurance team, both on the front end as well as the back end database side.

Pushes and backups for changes from Production and Staging.

Initiated standards for documenting full application lifecycle processing, procedures and best practices.

ENVIRONMENT: Amazon Web Services, DotNetNuke portal framework, SQL 2000, 2005 & 2008.

ASP, JavaScript, Jquery, IIS, SQL Server, C#, ASP.Net

SQL DBA / SQL Developer / Project Manager

Sigma Six Technologies Inc (New York) Dec 2005 – Jan 2006

Project management with particular focus on Information management.

Design & Development of Web Applications Using ASP, XML, HTML/DHTML, JavaScript (client and Server based), VBSCRIPT, SQL Server, LDAP

Logical and physical design of database, Data Modeling using Erwin.

Providing technical solutions for business issues.

Installation/Configuration/Maintenance of Web and Application Servers in Germany, Switzerland, Singapore and New York using Checkpoint SecureRemote VPN and Terminal Services.

Providing 24X7 Level 3 Support for Production systems and Servers.

Installation and Maintenance of Database Servers, Databases.

Troubleshooting user problems and fixing critical production issues.

ENVIRONMENT: Visual Basic, ASP, JavaScript, VBScript, Windows 2000/2003

Server, Exchange 2000 Server, IIS, SQL Server, Crystal Reports 9 Enterprise,

Altiris, Active Directory, Exchange Server, LDAP

SQL Developer

Cedaron Medical Inc ( Davis, CA ) Aug 2005 – Nov 2005

Analyze software requirements to determine feasibility of design within time and cost constraints.

Consult with hardware engineers and other engineering staff to evaluate interface between hardware and software, and operational and performance requirements of overall system.

Formulate and design software system, using scientific analysis and mathematical models to predict and measure outcome and consequences of design.

Develop and direct software system testing procedures, programming and documentation. Using ASP, XML, HTML/DHTML, JavaScript (client and Server based), VBSCRIPT, SQL Server

Analyze complex user requirements, procedures, and problems to automate processing and to improve existing computer systems.

Research, design, and develop computer software systems and scientific applications, applying principles and techniques of computer science, engineering and mathematical analysis.

Upgrade the completed system and correct errors to maintain system after implementation.

Enterprise Manager, T-SQL, stored procedures and queries.

Bulk import for over 500,000 records into multi-tier relational database.

Wrote and generated custom queries and reports based on users needs with little or no prior notice

ENVIRONMENT: .Net, SQL 2000

SQL DBA / SQL Developer / Project Manager

Sigma Six Technologies Inc (New York) Oct 2000 – July 2005

Project management with particular focus on Information management.

Design & Development of Web Applications Using ASP, XML, HTML/DHTML, JavaScript (client and Server based), VBSCRIPT, SQL Server, LDAP

Logical and physical design of database, Data Modeling using Erwin.

Providing technical solutions for business issues.

Installation/Configuration/Maintenance of Web and Application Servers in Germany, Switzerland, Singapore and New York using Checkpoint SecureRemote VPN and Terminal Services.

Providing 24X7 Level 3 Support for Production systems and Servers.

Installation and Maintenance of Database Servers, Databases.

Troubleshooting user problems and fixing critical production issues.

ENVIRONMENT: Visual Basic, ASP, JavaScript, VBScript, Windows 2000/2003 Server, Exchange

2000Server, IIS, SQL Server, Crystal Reports 9 Enterprise, Altiris,, Active

2001Directory, Exchange Server, LDAP

DataMatrix Consultants (India) Dec 1998 – Sep 2000

ENVIRONMENT: Visual Basic, ASP, VBScript, Visual Interdev, Windows NT 4.0, IIS, SQL Server

ROLE: Lead web developer

Spice Telecom (India) Mar 1997 – Nov 1998

ENVIRONMENT: Visual Basic, Windows NT, SQL Server, MS Access

ROLE: Manager Systems

DP Communication Systems Pvt. Ltd. (India) Dec 1996 – Mar 1997

ENVIRONMENT: Windows NT, Oracle

ROLE: Deputy Manager

Punjab Wireless Systems Ltd. (India) Dec 1989 – Nov 1996

ENVIRONMENT: UNIX, Ingres

ROLE: Assistant Manager

Punjab Khand Udyog Ltd. (India) Nov 1988 – Nov 1989

ENVIRONMENT: Cromix+, Cobol

ROLE: Programmer

Hero Cycles Pvt. Ltd. (India) Oct 1987 – Oct 1988

ENVIRONMENT: Basic

ROLE: Junior Programmer

References: Available upon request

Contact this candidate