Sql Server Data

Sign in Sql Server Data Location: Fremont, CA Salary: 65$/hr Posted: September 15, 2014 Contact this candidate Resume: Lakshmi Datla 469-***-**** *******.***@*****.*** Professional Summary * ***** ** ** ********** in SQL Server database admin, System Analysis, Design and Development and Support of Microsoft SQL Server2012/2008 R2 / 2008 / 2005 / 2000 in Development, Test and Production Environments on various business domains like Financial, Insurance and Manufacturing. • Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2012/2008/2005/2000 on Clustered and Standby Environments. • Migration from SQL server 2000 to 2005 and 2000/2005 to 2008 by using In-Place upgrade process and as well as side-by-side upgrade process, And documented the Upgrade Process and also expert in migrating DTS packages to SSIS Packages • Experience in implementing and Monitored different types HA and DR scenarios like Replication, log shipping and Configure Database Mirroring in Cluster Environment on Production, QA and Dev environments. • Configured the servers on 32 bit and 64 bitclustered and standalone server environments. • Experience in supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems • Expertise in Database Backup and Recovery procedures by using Native, TDP/TSM and LiteSpeed to/from Disk /Legato server (Tape). • Very Good Experience working with SCOM Monitoring • Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. • Experience in usingPerformance Monitor/Profilerto resolve Dead locks /Long running queries. And also good experience in data (table) partitioning. • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV’s and DMF’s, Re-indexing, Updating Statistics and online indexing. • Experience in data modeling like physical data modeling and logical data modeling by using ERWIN tool • Expert in data warehouse modeling (designing Star Schema, snowflake schemas with identifying Facts and Dimensions). • Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning Complex Queries. • Good experience on physical storage configuration and optimization of SAN/NAS/DASD with different RAID levels. • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors. • Checking the threshold values and baselines and monitoring in Perfmon and SCOM • Created linked servers between SQL Server 2000 & Oracle 9i, 10g & 11g and Teradata and DB2. • Expertise on Business Intelligence Tools to Create SSRS Reports, SSIS Packages and SSAS with OLAP. • Expertise in implementation of security models; Database authentication modes, creation of users, configuring permissions and assigning roles to users. • Expertise in performing data transformations between servers using BCP, DTS, SSIS and bulk insert. And also Expert in using DMV’s, DMF’s. • Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin. • Experience in managing Alerts, Operators and Jobs through SQL Server Agent. • 24 X 7 Production Database on Call Support. • Strong Technical background with excellent problem solving and communication skills. Strong time management skills and excellent team player with reputation of integrity and an ability to work on multiple technologies. Education Bachelor of Technology in Jawaharlal Nehru Technological University, Hyderabad, India Technical Skills SQL Server Reporting Services (SSRS) 2000/2005/2008R2/2012, Crystal Reporting Tools Reports, Cognos Framework Manager, Report Studio Database Tools SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer ERWIN, MS Visio Data Modeling Windows 98, Windows 2000 Advanced Server/Professional, Windows Server Operating Systems 2003, Windows NT, Windows XP Professional/Standard, Windows Vista Business/Ultimate, Windows 7 Ultimate PROFESSIONAL EXPERIENCE Bally Gaming Inc., Pleasanton, CAApr 2010 – Till date SQL Server DBA Bally Technologies provides the global gaming industry with innovative games, table game products, systems, mobile, and iGaming solutions that drive revenue and provide operating efficiencies for gaming operators. Responsibilities: • Upgraded Servers from SQL server 2008 to SQL server 2012 and installed service pack • Installed and configured SQL server 2008 and administered. • Migrated Databases, DTS packages, from SQL Server 2000 to SQL Server 2008. • Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures. • Involved in general Database administration, query performance tuning and validated some of the existing schemas • Responsible for maintaining all database environments Development, Testing, QA, Staging, and Production. • Administering SQL Server security and apply security across environments and trouble shoot security issues on daily basis. • Administered the SQL server 2000/2005/2008 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups. • User management by assigning appropriate permissions to the database users. • Experience in upgrading SQLServer and applying service packs and hot fixes and unattended Installations. • Experience in handling the situations in change control process. • Involved in database administration tasks and assisting developers with problems and SQL optimization. • Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis. • Experienced working on SQL COMPARE tool to compare the structures between databases in order to synch them • Expertise in Setting up database backup and recovery procedures for production, QA and development servers. • Installing SQL Server 2008 in windows Cluster environment. • Worked onSQL Server Clusters Active - Passiveon mission critical financial applications . • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment. • Involved in migrating database from oracle 11g to sql server 2008. • Actively involved in data warehousing of the Sybase database onto SQL SERVER 2008. • Experience with Dropping and recreate the tables for the damaged databases to avoid data loss. • Refresh the database from production to development and staging environment on daily basis. • Involved in the Backup & Restore and point in time recovery of the databases. • Responsible for developing, monitoring and deploying SSIS packages. • Loaded data from various sources like flat files, to SQL Server database Using SSIS Package. • Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed • Used Lookups Transformation to get the data from reference data sets. • Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases. • Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans. • Write SQL views against source tables in Oracle with business rules applied. • Created permanent tables, temporary tables and table variables. • Responsible for handling in high available clusters such as fail over clusters. • Conducted design reviews with users/team for development and production strategies. • Experience in handling in SOA environment. • Translating business requirements into technical design specifications and actively supported business users for change requests. • Developed DTS and SSIS packages to extract, transform and load (ETL) the data using SQL Server 2008 Integration Services and successfully completed DTS to SSIS conversion • Capacity-planning, Maintaining run book documentation on all the servers in word, pdf and excel formats. • Involved in handling onsite-offshore model. • On call 24/7 support to databases on weekly rotation. Environment: SQL Server 2012,2008 R2/2005/2000, Windows 2003\2008 64bit\32bit, VMware ESX\Vsphere5.1 lit speed, SQL backup5 Red Gate, SQL secure, ETL, SSIS, SSRS, C#., VB,ASP.NET,SSAS, System Monitor / Performance Monitor, VMware ESX, Share point 2007, Biztalk, TFS 2008,Microsoft Network monitor 3.4. Social Interest Solutions, Sacramento, CA May 2009 – Apr 2010 SQL SERVER DBA Social Interest Solutions (SIS), a mission-driven, nonprofit organization dedicated to leveraging technology innovation to improve consumers’ access to eligible health and human services. .Responsibilities: • Installation and Maintenance of SQL Server 2008 on Test, Development and Production Environments. • Implemented Database Mirroring and Transactional Replication as a part of DR plan. • Created a mirrored database on the report server using Database Mirroring with high performance mode. • Using Red gate SQL Compare tool to compare code in development and production environments. • Involved in migration of MS SQL Server 2000 to MS SQL Server 2005, 2008. • Installation of SQL Server 2005 on Standalone and Clustered Environments. • Assisted in Deploying 2 Node failover clustering. • Maintained and supported Clustered Windows Environment. • Handled Clustering between two Production Servers and performed daily backups and developed recovery procedures. • Configured Server for sending automatic mails to respective people when SSIS process fails. • Created, built and deployed successfully SSIS packages by using BIDS. • Migrated DTS packages to SSIS 2005 packages. • Used SSIS packages to transfer the data from legacy systems to SQL Server 2005. • Administered the MS SQL Server by creating User Logins with appropriate Roles, dropping and locking the logins, monitoring the User Accounts, granting and privileges to users. • Taking daily database backups by using Idera SQL safe backup tool . • Modify Stored Procedures and complex T-SQL Queries to improve query execution process. • Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements. • Implemented and Maintaining Replication. Generate every day morning Replication reports from branch SQL Servers and Resolve Issues. • Implemented Transactional Replication between Primary and Secondary Servers. • Created Linked Server between SQL Servers. • Worked with SQL Profiler/SQL Trace to Generate Traces. • Created jobs, Database Maintenance Plans and scheduled jobs according to requirements using SQL Server Agent. Environment: MS SQL Server 2000, 2005, 2008, Windows Server 2003, 2008 Cardinal Health, Piscataway, NJ Jan 2008 – May 2009 SQL SERVER DBA Cardinal Health is a Fortune 21 company that improves the cost-effectiveness of healthcare. As the business behind healthcare, Cardinal Health helps pharmacies, hospitals and ambulatory care sites focus on patient care while reducing costs, improving efficiency and quality, and increasing profitability. Responsibilities: • Create and maintain various databases for Production, Development and Testing Servers using MS SQL Server 2005/2008. Planning the location of data, indexes, and Transaction log files on the disk. • Install and configure SQL Server 2005/2008 on the server and client machines, provide connections and manage databases. • Assisted in Upgrading SQL Server 2000, 2005 databases to SQL Server 2008. • Planning, Implementing and troubleshooting Replication. • Involved in planning and monitoring Log Shipping. • Involved in SQL Server Hardening. • Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server. • Conducted root cause analysis of application availability and narrow down the issues related to coding practices, database bottlenecks, network latency and Resolve locking and blocking issues. • Configured up to 32 GB of memory. • Tuning the Production server to get the performance improvement. • Running Index tuning wizard for optimal query performance. • Implemented Database Mirroring as part of disaster recovery plan. • Implementing and Monitoring Transactional Replication and other SQL Server jobs using custom scripts. • Reviewed third party tools to automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs. • Monitoring SQL Server LOGS, Application logs and analyzing the logs. • Providing 24*7 supports to SQL application developers in implementing the applications on production server. • Maintaining both DEV and PRODUCTION Servers in sync. • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. • Creating Backup strategies and scheduling them as a part of database maintenance plans. • Environment:MS SQL Server 2000, 2005, 2008, Windows Server 2003, Windows 2000-Advanced server NT, XML. Contact this candidate PostJobFree Delete or Update my resume About Terms of Service Privacy FAQ Contact us