Neeraj Pal

• Provide technical and organizational leadership to database technologies (MS SQL SERVER and IBM DB2 )
• Establish a responsive database environment that proactively manages service levels and addresses database-related problems in a timely manner
• Participate in the development and management of quality, security, and integrity standards
• Actively participate in mentoring of peers and junior staff
• Perform database software installation, database instance creation, maintenance, performance management, and troubleshooting
• Provide technical guidance to peers, developers, and corporate users
• Lead the implementation of new and current versions of technology
• Data warehousing and creating OLAP servers using SSAS service
• Design, develop, and manage OLAP cubes, and ensure integration with other systems for seamless data flow and reporting capabilities
• Provide production support for database systems, applications and technologies
• Production outages may extend into off hours and require continuing support
• Develop methodology and standards for ongoing performance monitoring and problem resolution
• Establish procedures and guidelines for the security, access and availability of databases and related services
• Recognize and identify potential areas where revisions and/or changes need to occur and execute approved modifications
• Provide technical direction and leadership to peers and junior staff
• Administration of databases varying in size and complexity including - IBM DB2 (Linux, Unix & Windows), MS SQL Server & Oracle, PL/SQL, Performance monitoring, database design
• Experience performing installation, management, performance tuning and maintenance of databases in a distributed multiple vendor hardware and software environments

• Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications
• Managed indexes, statistics and optimized queries by using an execution plan for tuning the database
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts
• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files and load data into destination databases for further Data Analysis and Reporting
• Experience in using multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all
• Scheduled and executed SSIS Packages using SQL Server Agent
• Actively involved in generating Matrix, Sub reports and complex reports with multi-value parameters for the analysis of Performance.

• Creating and maintaining various databases on production/development servers and providing 24 x7 support
• Designing data warehouses and establishing OLAP servers through SSAS
• Construct, oversee, and handle OLAP cubes while guaranteeing smooth integration with other platforms for uninterrupted data transmission and enhanced reporting features
• Configured Log shipping from Production to Disaster Recovery server
• Involved in the development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification, replication verification, and indexing updates
• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers
• Identified, tested and resolved database performance issues to ensure data optimization
• Used tools like SQL Server Profiler, and Performance Monitor to identify bottlenecks
• Implementation of system-wide security policies and troubleshooting
• Involved in installing SQL Server 2008/2008 R2 on Development, Production
• Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication
• Deployed and scheduled SSIS package
• Setting up Failover Clustering in SQL server 2008 Active/Passive)
• Involved in migrating SQL Server Databases from Development to Production Server
• Managed Login and User: adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.

• Scheduled database backups and restore the Database from DR
• Provide 24/7 support to all Production, QA & Development MS SQL Server Environments
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server
• Configured Replication Server, and worked on replication server
• Logical and Physical Data Modeling using Erwin
• Identified the necessary steps to enhance user response time by checking fragmentation and re-index tables for efficient application access methods.

Completed Bachelor of Science (IT-IMS) from SMU in 2010.