Data Architect Agent Service

Balbir Singh

**** ******** **** **. 916-***-**** 9491 (C)

Carmichael CA, 95608 ****************@*****.***

Professional Summary

I have extensive experience in DataModeling, Relational Data Base architecture and Implementation, Systems Architecture and Development, Database Administration and implementation of Administration Standards & Practice using MS SQL Server about more than 10 years of DBA experience.. Over the years I have been involved in large number of project development, managed large number of Projects & been a DBA with large number of DataServers.

I have been associated with Medical/ School district/Financial services and Investment Banking . I have a lot of liaison experience between technology, marketing, operations and management.

Very well versed in translating Business requirements to Technology development/administration/maintenance. Well experienced in setting goals and priorities for technology to reflect business needs and rules. I have been involved all facets of Technology management and Business Liaison.

Well versed in database architecture and Troubleshooting issue on production database servers.

Technical Skills

30+ years experience (Three years in Hong Kong region) .10 + years in development and 20+ years in Data Architect and Database Administration.

Extensive experience in Data Modeling, DataBase Design, Data Architecting & Systems Architecting. Was involved in several Enterprise wide Technology Architecting & Implementation.

Complete Life Cycle experience in DB projects including Business Needs Analysis, Technology Selection, Capacity Planning, Design, Installation &Development, Maintenance & upgrades

Extensive experience in architecting, building and operating databases and servers for OLTP, Reporting and Business Intelligence (data warehousing) environments

Intensive knowledge of SQL Server 2017, 2014,2008,2005, 2000, 7.0, 6.5, Ervin DataModeler,

Implemented Always On Availability Group (AOAG) on Enterprise SQL server.

Setup Disaster Recovery (DR) and High availability options for MSSQL Server.

Implemented Backup and Restore stragies on production servers.

Experience in Windows server 2019 clustering service.

Knowledge of Big data like TeraData and Hadoop.

Experience in programming, support, installation and SQL Server Administration, Proven abilities to direct and troubleshoot, database administration, database programming.

Experience in overall management of the system including conceptual and physical database design, development, and data modeling, as well as support and performance tuning, User Management, Security, Backup and Recovery, Performance Tuning (with profiler) and Query optimization (with show plan ).

Proficient with back end development, writing stored procedures and triggers with Transact SQL ( T-SQL)

Experience in creating partition tables in SQL 2017

Experience in implementing Sliding Windows technology in SQL 2008.

Experience producing reports in Excel and Crystal Reports from a large complex database. (Large in the context of hundreds of tables and millions of records a year)

Experience in building complex queries and related reports.

Ability to assist customers in identifying data reporting needs

Ability to mentor co-workers in the above skills in a small or large group, or one to one setting

Experience in dimentional model and all three forms of normalization (1NF, 2NF, 3NF)

Ability to work in a fast paced environment and be adaptable to quickly changing needs and priorities

Setting up replication server for the organization.

Delphi (4.0, 3.0, 2.0, 1.0), Info power, VBScript, HTML, Clipper 5.0, Foxpro, MSAccess97, MS Access XP, Visual Basic, VB Application., Excel, Visual Basic. MS Project.

Experience in Object Oriented Programming & Client Server Architecture

Experience in Professional Reports like Report Smith, Quick Report, Instant Report & Seagate Crystal Report 8.5

Project Management skills like team co-ordination, team building, management reporting, resource allocation and job scheduling.

Experience in System Study / Analysis & Design, User consultation, support and training have been an integral part of the job

Professional Experience:

Sutter Health, Sacramento, CA, Jan’ 08 to Till Date

DBA

Data Requirement Analysis, Data Modeling and Data Architecture for Several projects and for several clients.

Setup Always on Availability Group (AOAG), Always On and Disaster Recovery (DR) options for MSSQL Server

Day-to-day DBA responsibilities for backups, uptime, performance & optimization of code developed by developers.

Day-to-day production management and automation of all necessary and helpful reporting and of care-and-feeding of mission critical databases and applications.

Wrote several hundred TSQL scripts to perform the inter-company and inter-system data transfers, validation and data controls and Maintenance script

Developed several hundreds of Stored Procedures using T-SQL Written Triggers in T-SQL..

Planned and implemented upgrade to SQL 2005 from SQL 2000 and SQl 2008.

Responsible for maintaining SQL Server databases.

Migrating databases from SQL 2008 to SQL 2017.

Working with networking people to setup Windows server 2019 clustering service.

Created Sliding windows for large tables which archive the old data to archive table for every three mont arhs to get the maximum performance of the system,

Implemented drive layout architecture for the new servers for better performance.

Implemented and Monitor fragmentation of the indexes and created script for indexes all the tables based on the level of fragmentation.

Implemented Backup/Recovery strategy. Introduced Hyperbac backup.

Implemented the database storage architecture to reduce the cost of hard disk space and saved dollar for the company.

Implemented the strategy for under utilization of the servers,

Installed and implemented SQL Server 2000,2008,2016,2017,2019 databases. Set up disk storage layout, moving tempdb and Transaction logs for better performance. Automate statistics.

Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability. Designed and populated reporting tables, views and stored procedures. Implemented partitioning to handle tables with over 1 TB.

Implemented data migration procedure using SSIS package.

Trained developers on how to write better queries, optimize their applications and to become junior database administrators.

Converted some huge tables into partition tables for better performance.

Department of Mental Health, Sacramento, CA Nov’04 to Jan’ 08

DBA/ Developer

Performed Business Requirement Analysis, Data Analysis and Modeling.

Performed Several Server installations, upgrades, maintenance, day-to-day operation, optimization and tuning.

Installation, Configuration, Upgrade Server. SQL Server Administration, Creating, Managing, Monitoring and Trouble Shooting Database.

Extracting and Transforming data using DTS Import Export Data, Bulk Insert, BCP, DTS Packages. Configured Jobs, Alerts, SQL Mail, Agent Experience in Replication. Managing & Monitoring SQL Server 2000 Security. Database Development like writing Store Procedures, Writing Transact SQL, Cursors, Triggers, Views, Indexes, and Constraints. Data Modeling. Developed IPC and Late reports in Crystal Reporting tools.

Writing monthly tasks in MS Project. Doing Data Analysis and Design for DSS system and converting into OLAP technology. Working with Users for analyzing the systems for reporting purpose. Build very complex queries for IPC, PASRR, SD/MC system. Created document based on the existing system.

Working on PSBC system (Provider Staff Background check) using MS Access, SQL Server, Business Objects and Crystal Reporting tools.

Converted DMH reports from Info Desktop to Business objects which are running successfully on the production system and also integrated Active Directory in Business objects which centralize the DMH security system.

Grant Joint Union High School District, McClellan, CA Nov’02 to Nov’04

DBA,

Performed Business Requirement Analysis, Data Analysis and Modeling.

Performed Several Server installations, upgrades, maintenance, day-to-day operation, optimization and tuning.

Installation, Configuration, Upgrade Server. SQL Server Administration, Creating, Managing, Monitoring and Trouble Shooting Database.

Development like writing Stored Procedures, Transact SQL, Cursors, Triggers, Views, Indexes, and Constraints. Successfully done Performance and Query Tuning of SQL Server Databases using tools like SQL Profiler, and Win NT Performance Monitoring. Provide support in Tuning of Database Application. Scheduled Backups and Restoration Plans and Point in Time Recovery. Implementing MS SQL Server Security and database permissions. Creating, Managing and Troubleshooting SQL Server Agent Jobs. Configure alerts and operators by using SQL Server Agent. Configure Replication, Log Shipping to meet Assist customers in identifying data reporting needs. Creating a productive development, staging, and production environment for Application Databases. Process App database changes/revision via a QA and migration process. Assist in debugging SQL Script. Assist in creating and editing DTS packages. Configures SQL Mail For MS SQL Server, SQL Server Agent and SQL Mail in Support Services. IOptimization of Query Performance and SQL Server Administration. Managing Database Users and Security. Importing Exporting Data between SQL Sever 7.0, 2000, Distributed queries with MS Access 2000 and Oracle 8i Database. Programming in VB 6.0 and Crystal Reports. Security and integrity of the system was maintained using stored procedures and database triggers were written in T-SQL and

Configuration of Linked Servers. Back ups and Restoration Plans. Snapshot and Transaction Replication. Developed reports Crystal Reporting tool. Design document throughout the system development life cycle in accordance with established industry standards. Build very complex queries for OLAP and reports. Design and developed Issue tracking system using Visual Basic application.

Environment : SQL Server 2000, VBScript, HTML, MSAccess97, MS Access XP, Visual Basic,

DTS, Crystal Report, OLAP, MS Project. Excel, VB Application,

Worked for following clients for R.System INC. from May’99 to Nov’02

RealNames.COM Nov’00 to Aug’02

DBA, Consultant

Understanding the Business Requirement and Designing the SQL Server 2000 Database. Installation and Registration of SQL Local as well Remote Server. Involved in Database Designing, Logical, Relational Database Diagram, Integrity Constraints and Finally Physical Data Modeling and Normalization. Migration of Access Objects to SQL Server 7.0.Created Tables, Indexes and Constraints. Programming with Transact-SQL, Batches, Transactions, Stored Procedures, Triggers and Cursors. Creating and, Created reports in Crystal reporting tool and Excel for large database for more than Millions records Administrating of all SQL Server Database Objects, Logins, Users and Permissions in each Registered Server. Manage Database Files, Transaction log, Estimate space requirements. Managing Ongoing activities like Importing and Exporting, Backup and Recovery. Define Hardware Requirement for New Servers and Upgrades of existing SQL Servers. Define QA Processes for Application Database on SQL Servers. Assist with Disaster Recovery and Back up Strategy. Configured SQL Server Agent service. Managing Database Users and Security. Used SQL Server Agent for Periodic Backups with Backup Devices, Database Maintenance Plan and Recovery. Database Tuning, Query optimization. Used DTS to Import or Export data from MS Access. Evaluated OLAP product for possible use on the project. I was responsible for Development life cycle of methodology. Developed monthly task in MS Project tool.

Environment : SQL Server (7.0,2000), VBScript, DTS, OLAP Tools, NT Server. Crystal Report,

MS Access, VB for Application, Visual Basic, MS Project.

AltaVista (Search Engine) Dec '99 to Oct'00

DBA, Consultant

Installation, Configuration, Upgrade Server. Creating, Managing, Monitoring and Trouble Shooting Database. Writing Transact SQL, SQL Server Administration. Extracting and Transforming data using DTS Import Export Data, Bulk Insert, BCP, DTS Packages. Configured Jobs, Alerts, SQL Mail, Agent Experience in Replication. Managing & Monitoring SQL Server 2000 Security and SQL Server 2000. Replication to Synchronize data between servers. Worked extensively MS SQL 7.0/2000 Database Development like writing Store Procedures, Cursors, Triggers, Views, Indexes, and Constraints. Data Modeling. Update Model from Database. Using Visio 5.0 Imported existing .erx and .vsd models to visio enterprise database model. Create forward and reverse engineered data models as well as assist in data modeling training. Based on the user requirement Access and VB application have been used to developed database application for the uses. Some reports have been developed in Excel spreadsheet.

Environment : SQL Server 7.0, DTS. ASP, IIS server, Crystal Report, Access, VB for application.

Visual Basic, Excel

Rounder Records Oct 99 to Dec 99

Database Developer, Consultant

Worked as a consultant for converting data from Interbase to Sql Server 7.0. Developed data conversion module in Delphi 4.0, which is very useful for this company to migrate data. Removed bugs from Financial Accounting software, which is running successfully. Developed Catalog System for Rounder Records Company, which contains song information for the singers. Delphi 4.0 as front-end and SQL server 7.0 as a back-end has been used for this system. Developed Excel and Crystal reports based on large data.

Environment : SQL Server 7.0, Delphi 4.0, Interbase, MS Access 97, DTS. Crystal Report,

Visual Basic. Excel.

California Department of Correction,USA May 99 to Oct 99

Developer, Consultant

Worked as a consultant for above mentioned System. The meal ticket system checks the meal ticket provided to employees. This system includes Meal ticket voucher entry, Employees entry and Ranking entry. This system provides various types of reports like Monthly Meal ticket reports, Daily Meal ticket report, Benefit form for the employees etc. Access97 as a back end and Visual Basic as front-end tools have been used to develop this system.

Environment : MSAccess97, Visual Basic, Crystal Report. Excel.

CyberLink Technology Co.Ltd., China Dec 98 to May 99

DBA/Developer

Worked as a Project Leader for Hotel Management System, which presents the graphical representation of incoming and outgoing data. This system checks all the activities of the staff and clients and shows the status of the room in colors like Check-in, Check-out, Vacant and whether the client is in the room or not. This system displays the Floor plan of the building indicating different room status. Paradox ver 7.0 as a database and Delphi 3 as front-end tools have been used to develop this system.

I also developed Product Delivery System using Paradox and Delphi 3. This system delivers the product according to the Purchase order in a FIFO method

Environment : SQL Server 6.5, Delphi 3, Visual Basic, DTS. Paradox

KAR Info Engg. Company Ltd., Honkong Mar 96 - Dec 98

DBA/Developer

Worked as a Project Lead for Smart Card System, which allows mangers to easily monitor employee work performance, attendance and productivity from their personal computers. This system also features automatic payroll calculation software, Door Lock and Internal Security Options. SQL Server and Delphi Pascal have been used for back and front end for developing this Human Resource Management Software. I handled some of the Calculative Modules and Reports. I have also developed the Project Tracking / Scheduling system. This System enables the user to have information regarding the number of projects running under each client, users can prepare Job Sheets, Quotations and Invoices, the kind of Complaints and Inquiries the clients have and whether they are attended to, in time or not. It also tracks down the schedule and duration of the Projects in hand and graphically illustrates the percentage of completion of each Project.

Environment : SQL Server 6.5, Paradox, Delphi 3.0

Timber World Resorts & Plantations India Ltd., India Dec 94 - Feb 96

Developer

I designed and developed Timber Investment Software System using Clipper 5.0 which is running successfully. This system maintains the records of the clients, including their investment details, Check details etc. It prints Certificates and Warrants for the Clients after receiving full amount. Every hundreds of application forms are fed on the Novell Network. I also developed Financial Accounting Software and the Payroll Software for this company. The Branch Accounting System was based on On-line Processing System which includes various reports like Cash Book, Bank Book, Journal Book, Account Statements, General Ledger, Party Ledger, Balance Sheet and Profit Loss A/c. Payroll Software System includes Pay slips, Pay sheets, Provident Fund List, Income Tax List. Advance deduction list and various other options.

Other Projects :

Mar 94 - Dec 94 worked in Deepak woolen Mills, India.

I have designed and developed Export documentation and Order Processing System in Clipper on Novell Netware. This System Includes Buyer’s Information, Supplier Information. Invoices and Packing List, Order in hand and shipping details.

Mar 92 - Mar 94 worked in Naveen Industrial Projects Ltd., India.

My main projects were Belt Conveyor System and Bank Guarantee System. The objective of the project was to computerize the whole system of mechanical job analysis like costing of different job loads, stress analysis, speed and height analysis. The bank guarantee system was to computerize the guarantee maintenance with the banks.

Mar 89 - Mar 92 worked in Indira International Export House, India.

The objective of the project was to computerize the Sales related activities and raise invoices per sales. The system was capable of handling sales accounting and sales analysis.

June 88 - Feb 89 worked in Havell’s Group of Industries, India.

Worked as a programmer and developed the various projects for inventory System and sales related activities project.

Contact this candidate