Nalini Devarakonda

Education

BE in Electronics and Communication (2001 - 2005)
National Institue of Engg, Mysore

Experience

Lead - SQL DBA for Mattel Inc at Wipro Technologies (Jun 2012 - Present)
Mattel, a global leader in the toy industry, strive to ensure that their toys are manufactured in a responsible manner, and their standards and oversight processes continue to evolve to reflect those expectations for ethical labor practices and environmental stewardship. o SQL Lead for Maintenance and Support of Global SQL Servers hosting database of the company with 24/7 support. The environment involves very large and complex databases in SQL Server 2008/2008 R2 and SQL Server 2005/ 2000/7.0 over the Windows 2000/2003/2008 (both physical/VM) having HA/DR solutions like log shipping, Mirroring, Replication (Transactional and P2P) and Clustering (active/active and active/passive). o SQL Subject Matter Expert - act as consultant to offshore team for SQL administration. o Prepare estimation and define technology assumptions that are presented to the customers keeping in mind the customer business problem/ technology road map and related application road maps as part of the new project implementation or enhancement involved. o Focus on customer satisfaction, developed clear business requirements; deployed standardized project-management processes and deliverables for implementing new projects to customers. o Responsible for coordination with other Wipro tower teams, retaining IT Organization of Mattel, handle escalations, carrying out hands and feet activities. o Act as escalation point lead on all Severity 1 issues as well managing Projects and seasonal spikes. For handling the work load from ongoing operations, seasonal spikes and projects, the teams will cross leverage bandwidths within the technology and functional groups.

Senior Database Administrator for Pitney Bowes Inc at Wipro Technologies (Mar 2008 - May 2012)
Pitney Bowes provides the most comprehensive suite of mail stream hardware and software solutions, and services for clients like USPS, UPS, Paypal etc. in US. There are over 150+ MS SQL Servers to be maintained and monitored. This Project involves the Migration and support of all Headquarters SQL Server 2000 databases to SQL Server 2005/2008. The project also involved migration and moving the PB environment physical to virtual to save license cost. Roles and Responsibilities: Lead and drive the team with technical guidance and quality process. Migration from Server 2000 databases to MSSQL 2005/2008. Installing and configuring MS SQL Service Packs applicable. Developing and testing a backup and disaster recovery Plan. Co-ordinate with Apps team to move the database/config/secutity Handling production support including ERT and On-call Support. Engineering initiatives for problem like reduction on alerts and incidents Deploying change control requests and ensure adherence to change control processes. Mange application level SQL security Establish and implementation on Database backups, Database recovery, Replications, Memory (Space) Problems, Security Features, Patch updates, Maximum number of users, connectivity Problems and Transaction Logs maintenance. Batch Jobs Monitoring. Review of existing database objects, their optimization and performance tuning and Data Archiving. Reviewing of existing batch jobs and making them more user-friendly (like adding alerts, emails etc).

DBA and T-sql Developer at Cognizant Technology Solutions (Nov 2005 - Feb 2008)
Establishing and implementing back up strategy for SQL service. Database optimization and performance tuning Performing query and system tuning and optimization to ensure code and use of SQL server is organized and efficient. Interface with data support group so that goals, expectations, concerns and issues are communicated effectively. Mange application level SQL security Helping new members of offshore team with their SQL server installation, setup and access issues. Addition/Deletion of users and their roles and access privileges. Understanding all applications and automate the processes that are currently done manually (New DTS Jobs). Reviewing of existing batch jobs and making them more user-friendly (like adding alerts, emails etc). Monitoring size and space related problems and Update Onsite and Offshore teams accordingly. Helping Onsite and Offshore team in database designs for new enhancements. Maintenance of transaction logs and Error logs. Database optimization and performance tuning Creating backup strategy for the databases Creation of MS SQL Server database devices, databases and database objects. Scheduling and managing jobs on MS SQL Server. Understanding the Databases of the different tools to be integrated Database design and application design T-SQL programming includes creating procedures, triggers, Job for archiving data. Implementing business rules. Participating in the application development process and code reviews of database objects.