Summary

• Extensive experience in database activities like data modeling, database design, development and maintenance, data transfer, documentation
• Expert in generating drill down Reports, handling parameterized Reports in SSRS 2005/2008
• Expert in transforming complex business logic into Database design and maintaining it by using Stored Procedures, User Defined Functions, Views, T-SQL Scripting and DTS
• Experienced in report generation using XML, Crystal Reports, SQL Server Reporting Services and Excel spreadsheet
• Extensive Experience in query optimization and Performance Tuning and troubleshooting
• Experience in conducting in-depth research and analysis to assess internal and external impacts related to system modifications
• Installing, upgrading, and configuring RHEL 3, 4, and 5 using Kickstart
• Efficiency in installing, configuring, and implementing of RAID 0, RAID 1, RAID 5 levels using Logical Volume Manager
• UNIX scripting/testing/debugging which includes Perl programming/scripting
• Experience in installation and maintenance of Apache web server and Sendmail agents
• Installed and maintained Windows Active Directory for sharing data using AD credentials
• Installed and maintained MySQL, PostgreSQL Database servers with users about 50-100 and role based privileges
• Installed, Configured and administered SQL Server 2005/2008 with scheduled backups and controlled user privileges
• Monitoring the health of Database servers for optimal performance and trace error/event logs for database errors
• Installed and configured monitoring programs such as Sun ILOM (Integrated Lights Out Manager), Nagios
• Experienced in the installation, support, configuration and maintenance of Linux, Windows, Sun Enterprise Servers, Dell PowerEdge Rack Servers
• Installation of kernel level patches and software packages on RHEL, Solaris, Windows Server 2003/2008
• Efficiency in upgrading firmware on various hardware including SUN, HP, DELL, IBM blades
• Installing and upgrading Red Hat Virtualization (RHEV-H) on Servers and VMware tools on client machines
• Creating and maintaining user accounts, profiles, security, rights, disk space, and process monitoring
• Installation and configuration of web hosting administration such as FTP, SSH, RSH, Telnet, and HTTP
• Configuring and administering NFS, NIS, NIS+, DNS, and SFTP on Unix server environment
• Networking communication skills and protocols such as TCP/IP, NFS, DNS, LDAP, DHCP, NTP and SMTP
• Expert in documentation and management of standard operating procedures, test plans and providing the best practices for the processes and delivered budget presentations
• Strong troubleshooting skills

Education/CERTIFICATION

• Master of Science (M.S.) in Systems Science
• Bachelor of Technology (B.Tech) in Electronics and Communications Engineering
• Sun Certified MySQL 5.0 Database Administrator (SCMDBA)
• Implementing and Maintaining Microsoft SQL server 2008 Reporting Services
• Microsoft SharePoint 2010, Application Development

HONORS

• International Honor Society Member
• Honor Society Member

Technical Skills

Operating System: RHEL 3, 4, 5; Solaris 8/10; Windows XP/2003/2008/Vista/7; Mac OS/X/Leopard/Lion Hardware: SUN Enterprise servers T5220, StorageTek 2540/2510 Array, Sun Fire v880, PowerEdge R910/R710/T610/2800/2600, PowerVault MD 1200/3200, Sun/Dell/IBM workstations, HP Network Printers Networking Services: KickStart, NFS, Apache,SendMail, Tomcat, SSH, Putty, WinSCP, CVS, VLAN, POP, SNMP, IMAP, RSYNC Protocols: DHCP, NIS, DNS, TCP/IP, FTP, SMTP, IPV4, LDAP, Samba Virtualization: VMware, Redhat Virtualization (RHEV-H) Database: MySQL, Oracle, PostgreSQL, SQL Server 2005/2008 ETL/BusinessIntelligence Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Servics (SSAS), Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, Data Transformation Services (DTS), Diagnostic Manager, perfmon, profiler, Team Foundation Server (TFS), SAS Admin Tools: Sun ILOM (Integrated Lights Out Manager), Solaris Volume Manager, Nagios, AWStats, Map Server, TWiki, Plone Design/Software: Photoshop, Dreamweaver, ColdFusion, Flash, MS Visio, MS office Languages/Scripting: C, Java, Perl, Shell Scripting (Bash), PHP, HTML, XML, CSS, Java Script, PL/SQL, ASP, ASP.NET, VB.NET

WORK Experience

Client: Confidential, LA Environment: SQL Server 2000/2005/2008, SSIS, SSRS 2005/2008, Visual Studio 2005/2008/2010, Microsoft SharePoint 2010, Business Intelligence Development Studio (BIDS), ASP, ASP.NET, VB.NET OS: Win XP/2003/7, VMware Role: IT Applications Programmer/Analyst II Duration: Feb 2011 - Present

Responsibilities:

• Responsible for providing production and development support of business critical applications
• Designed and developed databases for user applications as per business needs
• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application
• Analyze changes, enhancements and system designs to ensure data integrity and availability
• Assist in the evaluation of user requests for changes to determine specific tasks and effects on existing programs and systems
• Evaluated, examined and implemented user roles and assigned relative database access privileges
• Worked extensively with client gathering requirements to generate customized SQL reports
• Experienced in creating Jobs, Alerts using SQL Mail Agent
• Wrote distributed queries for Linked Servers
• Converted various T-SQL statements into stored procedures thereby reducing the number of database accesses
• Experience in integrating the SSRS reports into web applications using Report Viewer control, URL methods and creating data driven subscriptions to different users using Report Manager
• Involving in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data extraction, data loads and transformations
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Performed database normalization
• Handling database objects with enterprise manager and query analyzer
• Used performance monitor and SQL profiler to optimize queries and enhance the performance of database servers

Client: Confidential, LA Environment: Solaris Volume Manager, MySQL, SQL Server 2005, Dell PowerEdge R710/910, PowerVault MD 3200 OS: Win XP/2003/7; RHEL 3/4/5/5.5; VMware, Solaris 8/9/10 Role: Systems Administrator Duration: Aug 2008 - Jan 2011

Responsibilities:

• Installation and configuration of RHEL 4.x and 5.x, Windows 2003/2008 and Sun Solaris 8, 9, and 10
• Installing and monitoring of VERITAS Volume Manager (VxVM) and Logical Volume
• Installed and maintained Windows Active Directory for sharing data using AD credentials
• Handled Security and Network issues and applied necessary patches
• Creating soft partitions, and RAID levels using Solaris Volume Manager
• Performing day-to-day system administrator activities, troubleshooting, and storage assignments
• Maintaining Patches and Packages to keep the servers up to date with latest OS versions
• Configuring TCP/IP, NFS, NIS, and DNS environment and mounting and unmounting the file system
• Upgrading Solaris 8 to 10 and RHEL 3 to 5
• Automation of jobs through crontab and autosys
• Scripting in Bash and Perl for daily administration tasks
• Tuning kernel parameters in compliance to applications running on the server
• Maintained mailing lists and event calendar for the department
• Worked on all types of remedy tickets (Service desk, Change request, Port activation) assigned from various research groups which include password reset, upload/download files from/to Linux servers per user’s requirements, performance issues, allowing/blocking ports
• Coordinated with vendors like Sun, Dell and Microsoft for Server, Hardware and Software issues
• Worked on given technical that requires immediate attentions to ensure maximum system availability 24hrs, 7 days a week
• Documented server updates, issues and major configuration changes

Client: Confidential, Washington DC Environment: Apache 2.2, MySQL, Virtualization (RHEV-H), SUN Enterprise Server T5520, Coldfusion mx7, Flash, SunFire V880, PowerVault MD 1200 OS: RHEL 5.5, Windows Server 2003, Solaris 10 Role: Database Administrator/Web Developer Duration: Aug 2008 - Jan 2011

Responsibilities:

• Maintained corporate level website developed in LAMP environment (Website Link)
• Configured, maintained and administered Windows Servers with scheduled backups, user management and disk quotas
• Configured and maintained Apache Web server with about 12-15 distinct virtual host configurations
• Responsible for upgrading licenses and software applications for workstations and servers
• Installed and maintained MySQL, PostgreSQL Database servers with users about 100-150 and role based privileges
• Responsible for scheduled backups from Windows production servers to external mass storage drives
• Involved in OS Migration from FreeBSD 6 to RHEL 5
• Configured and maintained Windows server 2003 with shared directories and monitored with Sygate Personal Firewall Pro
• Designed and maintained forms for reservation facility using coldfusion and MySQL
• Creating users and granting roles, privileges based on user access requirements
• Worked closely with Development/Functional/Network teams to resolve issues
• Provide On-Call support on weekends and after hours
• Involved in shared DMZ configuration

Client: Confidential, India Environment: Apache 2.0, SQL Server 2003, WebLogic, Sun Ultra Sparc 60 OS: RHEL 3, 4; Windows Server 2003 Role: Jr. Systems Administrator Duration: Aug 2007 - May 2008

Responsibilities:

• Installation of Solaris using interactive and Jumpstart installation and Linux using Kickstart
• Installing, packaging and patching of Red Hat servers and Windows
• Setting up RAID levels on Sun Storage Equipments on new/existing production/development systems for reliability and fault tolerance
• Involved in configuration management, software deployment, change management, performance monitoring & tuning, and application maintenance of Servers/Workstations
• Implementing file sharing on the network by configuring NFS on the system to share essential resources
• User administration and management using add/change/delete control commands
• Documenting maintenance process and change management