OBJECTIVE

• Obtain a challenging position to contribute to an organization’s success through the use of my knowledge, skills and abilities.

SUMMARY

• Over 10 years of experience on leading Netezza data warehouse system.
• Over 2 year of experience on Teradata systems.
• Expert level knowledge in leading/managing/designing/supporting database’s in Netezza / Teradata Environment.
• Heavy experience on setting up netezza / Teradata data migration policies,
• Heavy experience working with netezza security model, Backup/Restore, purge/archive data, Reclaim / Groom data and Statistics generation strategies, Workload management, setting up GRA and managing all database administrator duties on Netezza database system.
• Designed & implement backup restore policyusing Teradata DSA backup.
• Over 8 years of experience with SQL Server including 7/2000/2005/2008 in Clustered environments.
• Over 8 years of experience in SQL server Performance tuning, logical and physical db optimization, hardware sizing and testing.
• Heavy experience in managing Dev/QA/production databases involving large dataset with over 200 databases.
• Extensive use of creating SQL queries, Indexes and Tables.
• Strong practice with Database availability, Data Transformation Services.
• Hands on experience on Microsoft reporting Services.
• Heavily involved in Data migration from db2 to Oracle 9i.
• Expert level knowledge of SQL server Database backups, Recovery procedures and Database Maintenance Tasks.
• Handling all SQL server database security issues.
• Scheduling and setting up jobs to run nightly using SQL server agents.
• Scheduling and setting up jobs using cron job for Netezza.
• Expert in figuring out/understanding needs, focusing on the important/real issues, translating them into technical actions and implementing a resulting database.
• Offers proven abilities as team player possesses strong communication, verbal and written skills.
• Self - motivated with exemplary analytical and problem solving skills developed through variety of projects.

TECHNICAL SKILLS

Database: Netezza 3.0/4.0/4.5.2 /4.6.6/5.0.6/5.0.8/6.0.5/7.0.2/7.1 , 7.2, Teradata 14, 15.10, MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008, MS SQL Server 2014, DTS, Stored Procedures, Triggers, Cursors, XML, T - SQL, PL/SQL, Access, MS Reporting Services, LiteSpeed, SpotLight, Sql Compare, Sql Configuration manager, Sql Diagnostic Manager, Sql Secure, Oracle 9.i, Embarcadero DB Artisan 8.5.2/8.5.5 , Sql Navigator, Toad, WinSql, Db2, Hive, Hortonworks Frame Work. Teradata view point, Teradata DSA backups.

Platform: W2K, Win2003, WIN NT, LAN, FTP, TCP/IP, Solris 8/ 9.

Programming / Applications: Visual Basic, VBScript, TSQL, PL/SQL, Informatica.,Visual Studio 2005, Mercury Test Director, Remedy, Visual Source Safe, Microsoft Office Suite, Photoshop, Veritas Back-Up Exec., MS Exchange, Seapine, Quality Center, Open MSM Marval, ANT, Hudson, Buildforge, Tidal. Lotus Notes, Hortonworks Frame Work.

PROFESSIONAL EXPERIENCE

Confidential

Senior leadNetezza Architect/ Admin

Responsibilities:

• Responsible to Lead / manage netezza warehousing environment running on NZ 4.6/5.0/6.0 /7.0 version
• Responsible to lead all other Architect / DBA’s.
• Responsible to gather user requirement and distribute & manage the workload with the team.
• Responsible to create database/tables/views/synonyms/groups/users as needed
• Responsible to work / Coordinate with netezza / Teradata support to bring up new netezza / Teradata appliance.
• Responsible to work with netezza / Teradata support in upgrading / Patching netezza / Teradata versions.
• Involved in data architectural process to foresee any upcoming changes.
• Overlook all the system migrations.
• Design & implement backup / recovery process.
• Design process to migrate production data across different servers.
• Worked closely with data modelers in the data model change process
• Setup Extract, archive / purge process using external table.
• Designed a data migration process from existing production server to their new BI Netezza server.
• Worked closely with ETL team and all the end users to setup a resource allocation policy.

Confidential

Senior Database Administrator

Responsibilities:

• Responsible to administer and configure Data warehousing environment (Netezza 3.0/4.0/4.5.2 ).
• Created System generated notification to monitor system alerts in the event of hardware failure, Disk utilization, SPU swap partition utilization for Netezza Db system.
• Design and create backup/restore policy for Netezza databases.
• Design, create and maintain roles and users for Netezza environment.
• Install and administer sql server 2005 Database Clustering (Active\Passive And Active/Active).
• Install, administer, and configure sql server 2008.
• Make infrastructure recommendations (Server \s memory, CPU or upgrades).
• Consolidate servers to cut heavy cost in SQL licensing.
• Install and configure Mysql on windows environment.
• Create views, Stored proc, Packages in PL/SQL.
• Wrote trigger to setup audit trails for high volume tables.
• Designed and setup the ODS environment.
• Create Archive/Purge/Restore policy for the historical data.
• Worked closely with Oracle database administrator in migrating databases from Db2 onto oracle using Oracle Heterogeneous services.
• Proactively monitoring the performance and tuning of SQL server databases. Monitor the daily performance of the production database.
• Database Backups and Restores using litespeed.
• Created automated reports using Microsoft SQL server reporting services.
• Assist in setting and maintaining standards for the SQL environments concerning security, installation and upgrades.
• Database Roles and Security.
• Schedule jobs and queries.

Confidential

Senior Database Administrator

Responsibilities:

• Proactively monitoring the performance and tuning of SQL server databases. Monitor the daily performance of the production database
• Database Backups and Restores
• Data Transfers using Microsoft DTS
• Assist in setting and maintaining standards for the SQL environments concerning security, installation and upgrades.
• Database Roles and Security
• Perform routine database administration duties and provide documentation and change control logs where needed. Schedule jobs and queries.
• Use database replication/synchronization techniques.
• Perform some application development, including stored procedures, triggers, design changes and improvements, using transact-SQL or PL/SQL.
• Create Reports and Scripts which is being used by billing.
• Make infrastructure recommendations (Server \s memory, CPU or upgrades).
• Database Clustering (Active\Passive)

Confidential

Database Administrator

Responsibilities:

• Database Administration. Management of production, development, and training databases on SQL servers (SQL Server 2000) in a 24x7 environment (production only); maintenance including backups/restores; security.
• Schedule jobs and queries.
• Database Roles and Security
• Daily Support, administration and maintenance of SQL Server instances and user databases .
• Database development. Creation and scheduling of DTS packages. Creation of stored procedures and views.
• Conversion of legacy system to SQL Server.
• SAN. Planning for future growth/use; installation/configuration including knowledge of various RAID levels.
• Upgrading to new Microsoft releases and applying latest Microsoft Service Packs and Patches.
• Data Warehousing. Monitoring of existing automation; additions and modifications to ETL processes.