We provide IT Staff Augmentation Services!

Netezza Dba Resume

Plymouth, MN

SUMMARY:

  • Twelve and Half years of experience in Database Administration, Architecture, Design, Implementation, Performance Tuning, Deployment, Development, Capacity Planning, Scaling & Support of Mission Critical MS SQL Servers 2014/2012/2008 R 2/2008/2005/2000 /7 in Development, Production, Test, Replication, Cluster, QA and VLDB Environments.
  • Three Plus years of Netezza Administration and Development Experience.
  • Installed, configured, maintained and monitored MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 /7.0 Versions in both Mission Critical, Clustered (Active/Passive and Active/Active), Stand - Alone, Hyper-V and VMware Environments.
  • Deployed SQL Server 2012 Databases to SQL Azure.
  • Created Disaster Recovery Plans and tested them.
  • Implemented High Availability plans like Always on Availability Groups, Clustering, database mirroring & Log shipping.
  • Improved the performance of the databases, SQL Servers, Windows Servers, applications and optimized the slow running queries.
  • Detected and resolved the performance issues of the SQL Server relating to CPU, Memory, I/O, tempdb, disk space and contention issues.
  • Performed Database Optimization, Server Optimization, Consolidation and Standardization.
  • Resolved issues related to database performance, database capacity, Cluster, replication and migration.
  • Used Performance Monitor/Profiler to resolve the Blocking, Dead Locks and Long Running Queries.
  • Used DMV’s, Traces, System Stored Procedures, User defined stored Procedures, DBCC Commands, Wait Statistics, Perfmon Counters, Extended Events, third party Tools to resolve performance Issues.
  • Checked the Query Execution Plans, Operators and optimized the Queries.
  • Performed Upgrades & Migration from SQL Server 2000 to SQL Server 2005/2008/2008 R2, SQL Server 2005 to SQL Server 2008/2008 R2, SQL Server 2008 to SQL Server 2008 R2, SQL Server 2008 R2 to SQL Server 2012 and SQL Server 2012 to SQL Server 2014 in both 32 bit and 64 bit environments and resolved the issues.
  • Performed Migrations from SQL Server 2012 Data Warehouses and Data Marts to SQL Server Parallel Data Warehouse(PDW).
  • Performed Migrations from Oracle, DB2, Sybase Adaptive Server Enterprise 15.0/15.7and MYSQL to SQL Server 2005/ 2008/ 2008 R2/2012/2014 and from SQL Server 2005/2008/2008 R2/2012 to Netezza.
  • Designed, implemented & tested Archiving, Database Backups, Point in time Restores and Disaster Recovery Procedures.
  • Resolved Database, Performance, Replication, Always on Availability Groups, Clustering, log-shipping, Database Mirroring, Connectivity, Security, Log, blocking and dead locking related Issues.
  • Used ETL tools like DTS, SSIS and automated the collection of the data from various Data Sources like Netezza, Oracle, SQL Server, Excel, flat files, DB2 applied the transformations, cleaned the data and loaded the data into Staging, ODS and Data ware-houses.
  • Used SSIS Packages to clean the data, transform the data and load the data into flat files, Excel, Oracle, Netezza, DB2 and SQL Server Databases.
  • Created DTS, SSIS Packages and deployed them.
  • Performed Data Modeling, Conceptual, Logical and Physical database design using Erwin Tool.
  • Implemented SQL Server 2014/2012/2008 R2\2008\2005\2000 Best Practices, Management Data Warehouse, different types of Replication models like Snapshot, Merge, transactional replication and monitored them.
  • Created Reports with parameters using Microsoft Reporting Services (SSRS) and Crystal Reports.
  • Created Subscriptions, Dashboard and Scorecards.
  • Setup and configured Reporting Servers for Optimal Performance in a Load Balanced Environments.
  • Experience in Resolving Tickets, Software Development Life Cycle (SDLC), SQL Server Memory Management, Incident Management, Change Management, Version Control, OLTP, OLAP, MS-DTC and fixing the database corruption.
  • Used Tools like DAC, SQL Litespeed for backup-recovery and Performance Advisor, Extended Events, Spotlight for performance tuning.
  • Performed Schema Management, Client/Server Connectivity, Database Rollouts, Load Testing, Load Balancing, Database consistency checks using DBCC Utilities.
  • Created Linked Servers, Maintenance Plans, Entity-Relationship Diagrams, Perl Scripts, VB Scripts and Power shell Scripts.
  • Involved in the Design of Databases and database objects like Tables, Indexes, stored procedures, Table-Valued functions, Scalar-Valued functions, Aggregate functions and Views.
  • Archived SQL Server data using Partitioning.
  • Created VLDBs, Logins, Users and controlled their permissions and access by using Server Roles, Database Roles and User defined Roles.
  • Created Jobs and had set up the Database Mail and Alerts using the SQL Server Database Mail and SQL Mail.
  • Configured and Maintained the Report Server and the Report Manager.
  • Installed SQL Server 2005/2008/2008 R2/2012 Reporting Services in SharePoint integrated Mode and had done configurations on the MOSS box.
  • Designed and implemented OS Layout for Oracle, SQL Server, OLTP Databases, Fact Tables, Dimensions Tables, Star Schemas, Snow Flake Schemas, Data-ware Houses (Kimball and Inmon), Data Marts, Data Mining and Reporting Servers.
  • Created Multi-Dimensional Cubes, OLAP Cubes and modified the cubes using Cube Designer.
  • Created Dimensions, Hierarchies, Local Partitions, Remote Partitions, KPIs, Attributes, Measures, Measure Groups, Calculated Members, Perspectives and Translations.
  • Processed the Cubes and Dimensions.
  • Created Analysis Services Databases, and performed the database Backups and restores.
  • Wrote MDX Queries, MDX expressions for cube calculations and KPIs.
  • Performed Geospatial Analysis.
  • Tuned Cubes and Dimensions
  • Detected SQL Injection and eliminated it.
  • Prepared project documents like Change requests, Status reports, Issue tracking.
  • Implemented Change Releases to Production.
  • Implemented policies and procedures for ensuring the security and integrity of the SQL Server databases.
  • Experience in Security management, auditing (Sarbanes-Oxley) and user access control on the databases and Servers.
  • Installed, Configured, Monitored Oracle 10g/11g/12c on Windows/Linux Servers.
  • Monitored Errors, Alerts in Oracle.
  • Created Users in Oracle and controlled their access through Roles and Privileges.
  • Performed RMAN backups and Restores.
  • Performance Tuned Oracle Servers, databases and queries.
  • Created Tables, tablespaces, Views, Stored Procedures, Sequence, Synonyms, Indexes, alerts, Maintenance Windows in Oracle.
  • Created Jobs and scheduled them in oracle.
  • Loading the data into the tables in Oracle database.
  • Created Databases, Tables, Views, and Stored Procedures, Events in Netezza and optimized them.
  • Created Users, Groups and Maintained the security of the users, Groups in Netezza.
  • Performed Netezza database maintenance, Netezza backups and restored them.
  • Loaded data into tables in Netezza using NZLoad.
  • Writing shell scripts and scheduling the cron Jobs.
  • Troubleshooting the Query performance Issues and system performance issues like (H/W,SPU/SPA/Switches/SAS Gig Ethernet Switches).
  • Performing Netezza Databases Backups using TSM and restores.
  • Installed SQL Extensions and INZA Analytics on Netezza.
  • Creating Performance Baselines in SQL Server and Netezza.
  • Performed Capacity Planning in SQL Server and Netezza.
  • Performed Migrations from Twinfin and Stripper to Mako.
  • Analyzing the Netezza Log files for fixing the performance issues.
  • Setup CallHome, Query History DB, Performance Portal, Health Checks in Netezza.
  • Implementing the Best Practices in SQL Server and Netezza.
  • Applied Fix Packs on Netezza.
  • Worked on Netezza Encryption and Netezza Key Management and trouble shooted issues related to it.
  • Provided 24X7 on call Production Support for the Deployments, Migrations, Applications and SQL Servers.
  • Provided Knowledge Transfer, Training to the Users on Databases.
  • Excellent Oral and written communication skills.

TECHNICAL SKILLS:

Databases: MS-SQL Server 2014/2012/2008 R 2/2008/2005/2000 /7.0 , MS Access, Oracle 9i/10g/11g/12c, Netezza 7.2/7.0.5/7.0/6.0.5 , Sybase ASE 15.0/15.7, DB2, MySQL, SQL Azure, DB2 9.7/10.5, GreenPlum 4.2, HP Vertica 7.0.0, Teradata 13/13.10/14, MongoDB 3.0, Informix

Languages: T-SQL, PL/SQL, NZPLSQL, ASP.Net, VB.Net, C, C++, ColdFusion MX, XML, XSLT, SQL PL, HiveQL

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import, MS BI Dev Studio, SSAS, Client Network Utility, Server Network Utility, SQLCMD, SQLDIAG, SQL Server Configuration Manager, Service Broker, BCP, Database Engine Tuning Advisor, Replication Monitor, Report Services Configuration tool, T-SQL Debugger, Activity Monitor, Resource Governor, Performance Data Collector, Policy Based Management, Central Management Server, Compressed Backups, SQL Server Audit, Data Compression, Cube Designer, Dimension Designer, Mining Model Viewer, Master Data Services Configuration Manager, Master Data Manager, dwconfig, PDW Migration Advisor(PDWMA)

BigData: MapReduce, Tez, HCatalog, HBase, Accumulo, Storm, Solr, Spark, YARN, HDFS, Ambari 2.0, ZooKeeper,, Oozie, Flume, Kafka, Falcon, HDInsight, Capacity Scheduler, Datameer, Cloudera, Sqoop, Avro, Mahout

Hadoop: Hadoop Common, Hadoop Distributed File System (HDFS), Hadoop YARN, Hadoop MapReduce, PivotalHD, Cloudera, HortonWorks

Work Flow: Oozie

Data Integration: Flume, Sqoop Massively Parallel Processing(MPP) Appliance: SQL Server Parallel Data Warehouse(PDW)

Netezza: Mako, Striper, TwinFin 3, Model 1000-3, Host Model x3650 M3, Host Model x3650 M4, Host Model x3750 M4, NPS 6.0.5.P2/7.0.P2/7.0.P5/, 7.0.4.4-P1/ 7.2.0.3 P2, 1000 DW Appliance, NZADMIN, NZLOAD, Netezza Performance Portal v 2.1.0.0\2.1.1.1, Web Admin,N, N, N, N, N, SQL Extensions 7.2,NZ Analytics v3.2.0, nzbackup, nzcontents, nzhostbackup, nzhostrestore, nzrestore, nzstart, nzstop, nzconvert, nzds, nzevent, nzhw, nzload, nzodbcsql, nzpassword, nzreclaim, nzrev, nzsession, nzspupart, nzsql, nzstate, nzstats, nzsystem, nz migrate, nzload, nzhistcleanupdb

Oracle Tools: SQL Developer 4.1/4.0/3.2/3.1/3.0 , SQL Developer Data Modeler, SQL Plus, Oracle Enterprise Manager, Oracle Application Express(APEX), Warehouse Builder, Business Intelligence Discoverer 11g, Recovery Manager(RMAN), Real Application Clusters, Golden Gate, Data Guard, Active Data Guard, Database in Memory, Database Upgrade Assistant(DBUA),Oracle Data Integrator

Teradata Tools: Teradata Studio, BTEQ, Teradata SQL Assistant, SQL Assistant, Management portlets, Viewpoint, Active System Management portlets, Workload Analyzer, Analyst Pack, SystemEmulation Tool, Index Wizard, TPump, FastLoad, MultiLoad, FastExport, Unity and query routing, Parallel Transporter, ARCMAIN, Aggregate Designer, Warehouse Miner, Profiler, Analytic Data Set Generator.

DB2 Tools: db2pd,db2diag,db2top,db2support,db2caem,db2trc,db2dart,INSPECT,vmstat,iostat,ps,svmon,db2advis, IBM Data Studio 3.1

Web Servers: IIS 6/7, Web Logic, Sun One (Web Server 6.1)

Framework: .NET Framework 1.0/2.0/3.0/3.5/4.0/4.5 , Apache Hadoop 2.5.2,Hadoop YARN, Hue

ETL Tools: DTS, SSIS, IBM Info Sphere DataStage, Abinitio, Informatica

Reporting Tools: SSRS, Crystal Reports 2008, Report Designer, Report Builder, Report Manager, RSKeymgmt, RS, Model Designer, Hyperion, Congo s 8 Business Intelligence, Dundas Chart for Reporting Services, ProClarity, LogiXML, mysqlreport, Power Pivot, Power View, Power Query, Power Map, Microstrategy Analytics, Tableau

Back UP Tools: Idera s SQL Safe backup, Quest s Litespeed, IBM s Tivoli Storage Manager, Red Gates SQL Backup, RMAN

Change Management Tools: Idera s SQL Change Manager, Quest s Change Director, Embarcadero Change Manager, HP Service Manager(HPSM)

Cluster: Cluster Administrator, Veritas Cluster Server, Veritas Cluster Server Web-based Cluster management console(VCS MC)

Data Modeling Tools: Erwin Data Modeler, Erwin Data Model Validator, ER/Studio, MS Visio, Quest Toad Data Modeler, Sybase s Power Designer

Performance Monitor Tools: Perfmon, SQL ultimate Performance Monitor, Foglight Performance Analysis, Spotlight, SQL Diagnostic Manager, SQLdiag, SQL Sentry 7.5, PAL,SQL Trace, SQL Nexus, dmv s, Extended Events, Management Data Warehouse, phpMYAdmin, MySQL Tuning Primer Script, MySQLTuner, mytop, innotop, DAC, Spotlight on oracle 9.6, Memory Visualizer, Activity Monitor, Event Analyzer, Health Center, InfoSphere Optim Performance Manager V5.3, Optim Query Workload Tuner for DB2 v5.3, Optim Query Tuner for DB2, FODC, MONREPORT, Process Explorer, Extended Insight, Management Console (MC), Ganglia 3.7.1/3.6.2

SharePoint: SharePoint Server 2013, SharePoint Server 2010, Microsoft Office SharePoint Server 2007, Windows SharePoint Services 3.0, Office SharePoint Designer 2007, Power Pivot Gallery

Scripting: Power Shell 1/2/3, Shell Script, Java Script, VB Script, Pig

VPN Tools: Cisco AnyConnect VPN,RSA SecureID

Other Tools: Visual Studio 2005/2008/2010/2012/2013 , LINQ, Legato Networker, event viewer, FTP, SQL Server Migration Assistant for Oracle, MS-DTC, Visual Source Safe, Visual Studio Team System (VSTS), Team Foundation Server (TFS), Microsoft Baseline Security Analyzer(MBSA), WinSQL, Ultra Edit, Opsware, DB Artisan, NZADMIN 7.0/7.0.5,Active Directory, NTLM, Kerberos, Power BI, System Center 2012, System Center Service Manager 2010, System Center Operations Manager 2007 R2/2007/2005, System Center Data Protection Manager 2010/2007, HP Operations Manager, SQ Data, Office 365, Tableau, pgAdmin III, Sybase Central v6.0,Toad for Oracle 12.1,Toad for MySQL 6.3,Toad for DB2 4.7,Toad Data Modeler 5.1, Quest SQL Optimizer 8.8.1 for Oracle, DbVisualizer 9.2, Benchmark Factory for Databases, Aginity Workbench for PureData System for Analytics, Tortoise SVN, MySQL Workbench 5.2, Attachmate Reflection, HeidiSQL 9.1, Cisco Tidal Enterprise Scheduler 6.2, CA Autosys Workload automation v11.3,dwloader,PowerPivot

Operating System: Windows NT 2012 R2/2012/2008R 2/ 2008/2003/2000 /4.0/ XP/Vista/7/8/8.1, Unix, Wintel Server, Linux 5.7, Mac OS X, Windows Azure, Oracle Solaris 10, HP-UX 11i, IBM AIX 6.1

Gaming: IGT Advantage 9.1, IGT SBX 4.1, EZPay 9.1, TableManager 9.1, Tournament Manager 2.0, Bravo, eMarker

VMware: vSphere Client 4.0/4.1/5.0/5.5

Slot Systems: Oasis, CMS, LMS, Legacy

SAN: HSG80/EVA5000/EVA8000/AMS2500/HDS AMS2500(40 TB), EMC VNX 5500/5700, Netapp FAS 3240

Networking: NAS,DAS,LAN,WAN,TCP/IP, DNS, VPN, Intranet, Terminal Services

EXPERIENCE:

Confidential, Plymouth, MN

Netezza DBA

Responsibilities:

  • The project was to Provide Database Administration support on MPP systems such as Netezza which includes software installation, configuration, upgrading/patching, database system management, monitoring, tuning and optimizing, troubleshooting and maintenance.
  • Uphold enterprise policy guidelines and recommend new and improved guidelines to ensure compatibility and better service for end-users.
  • Performing capacity monitoring and short and long-term capacity planning in collaboration with development resources, system administrators and system architects.
  • Maintain security according to best practices and general security solutions that balance auditor requirements with user requirements.
  • Writing shell scripts and automating them. Participating in 24X7 on call rotation and customer service experience.
  • Implement DR Strategy for Netezza databases.
  • Identifying and initiating resolutions to user problems/concerns associated with Netezza functionality (hardware and software)
  • Staying abreast of the most current release of Netezza including compatibility issues with operating systems, new functionalities and utilities.

Environment: NzAdmin, Aginity Workbench for Netezza, IBM Netezza Performance Portal v 2.1.0.0\2.1.1.1, Putty, Ultra Edit, Netezza 7.2.0.3 P2/7.0.4.4-P1, NZPLSQL, Shell Script, Red Hat Enterprise Linux, Attachmate Reflection, Cisco Unified Personal Communicator 8, Jabber, Cisco Anyconnect Secure Mobility, VMWare Horizon View Client, Ultraedit, Webex, Sharepoint Workspace 2010, N, N, N, N, N, Host Model x3650 M4, Host Model x3750 M4,SQL Extensions 7.2,NZ Analytics v3.2.0, Aquadata Studio 8, Quest Toad 2.5.1, SAS 9.3 M1, BASE SAS 9.3 M1, SAS/ACCESS 9.3 M1, SAS Add in for MS Office 9.3 M1, SAS Enterprise Guide 9.3 M1, SAS Drivers for ODBC 9.3 M1, PC SAS 9.2/9.3/9.4, SAS Server 9.3/9.4, Informatica 9.6.1 HF1, Microstrategy 9.2.x, Tableau 8.2

Confidential, West Palm Beach, FL

Sr. SQL Server DBA/ Architect/BI Developer

Responsibilities:

  • The project was to Implement SQL Server 2012 Always on Availability Groups on Windows Server 2012 R2 standalone servers.
  • Created, optimize and tested the Databases, Tables, Views, and Stored Procedures.
  • Applied Best Practices in setting up SQL Server 2012 .
  • Trouble-shooted and Deployed SSIS Packages. Setup Jobs, Alerts, Operators, Database mail and Database Maintenance Jobs in SQL Server 2012.
  • Provide Support to applications like Quillix, Tokay, Connect 3, One Solution, ESRI, Fleet and Control Pad.
  • Used DAC tool for performance tuning.

Environment: SQL Server 2014/2012/2008 R 2/2008/2005/2000 , SSIS, SSAS, SSRS, Windows Server 2012 R 2/ /2003/2000 /7 , Netapp FAS 3240

Confidential, Hagerstown, MD

Sr. SQL Server DBA/ Architect/BI Developer and Netezza Developer

Responsibilities:

  • The project was to Creating, optimize and test the Databases, Tables, Views, and Stored Procedures.
  • Applying Best Practices in writing the Stored Procedures.
  • Provided Recommendations on the Stored Procedures. Took Netezza databases backups and restored them.
  • Performed Database Migrations from Sybase Adaptive Server Enterprise 15.7, MYSQL and DB2 to SQL Server 2012/2014 and SQL Server 2012 to Netezza.
  • Setup Parallel Data Warehouse, Always on Availability Groups on SQL Server 2012.
  • Installed SQL Server Clusters on active- active Node.
  • Trouble-shooted and Deployed SSIS Packages.
  • Created SSIS Packages and loaded the data into Netezza and SQL Server databases.
  • Performed Database Maintenance in Netezza and SQL Server. Used Datastage to load the data into Netezza.
  • Performed patch installations in Netezza. Created Reports using SSRS and scheduled them.
  • Created SQL Server Disaster recovery plans and tested them.
  • Created Tivoli Data warehouse, Data warehouses (Kimball), Cubes and wrote MDX Queries.
  • Creating Inventory SQL Server reports using SSRS and Moving to the Service Manager. Installing and administering IBM DataPower SOA Appliances.

Environment: SQL Server 2014/2012/2008 R2/2008, SSIS, SSAS, SSRS, TwinFin 3, NPS 7.0.P5, 1000 DW Appliance, SharePoint Server 2013, RedGate SQL Monitor, RedGate SQL Admin Bundle, System Center 2012, Sybase Adaptive Server Enterprise 15.7

Confidential, Atlantic City, NJ

Sr. SQL Server DBA/ Architect/BI Developer and Netezza Admin

Responsibilities:

  • Responsibilities were to perform Monitoring, Performance Tuning, Troubleshooting the issues, Backup and Restores, provide High Availability, Security, Design specifications for the OLTP server, databases, Transactional Replication, Perform Auditing, Creating SSIS Packages and scheduling the Jobs, Perform Capacity Planning, Setting up Tivoli Data warehouse, Management Data Warehouse, Parallel Data Warehouse, Always on Availability Groups, Alerts and Notifications, Creating Disaster Recovery Plans and testing them.
  • Created Analysis Services Databases, taking their backups and restoring them.
  • Creating Cubes, Dimensions, Hierarchies, Attributes. Giving access to the users in Analysis Services.
  • Tuned the cubes and dimensions. Creating Data warehouses (Kimball and Inmon), Loading the data into data warehouses and generating SSRS Reports, Creating, optimize and test the Databases, Tables, Views, Functions and Stored Procedures. Applying Best Practices in writing the Stored Procedures.
  • Providing Recommendations on the Stored Procedures.
  • Taking Netezza databases backups and restoring them. Performed Database Migrations from Oracle, Sybase Adaptive Server Enterprise 15.0, MYSQL and DB2 to SQL Server 2008 R2 and SQL Server 2008 R2 to Netezza. Provide Support to applications like IGT(Advantage & SBX),Bravo, eMarker, Infogenesis Universal Desktop 4.3.1, RedRock, MGT, UltiPro, Bartech, SolarWinds, SharePoint, Labor Scheduler, BellDesk, AllStar, Fusion, Nagios, MDM, Scannet, NetPay, iTrack, Performance Management, Four Winds and CallCopy.
  • Used Datastage to load the data into Netezza. Performing Netezza database Maintenance and patch installations.
  • Creating Inventory SQL Server reports using SSRS and Moving to the Service Manager.
  • Installing and administering IBM DataPower SOA Appliances.
  • Installed SQL Azure databases and performed maintenance on them in Windows azure.
  • Monitored and tuned the Performance of the SQL Azure databases.
  • Configuring the firewalls. Performed Geospatial Analysis.

Environment: SQL Server 2012/2008R 2/2008/2005/2000 , MS Visual Studio 2012/2010, MS BI Dev. Studio, Enterprise Manager, SSIS, SSAS, SSRS, IIS, Query Analyzer, DMV’s, Vb.NET, C#, MS Visio, Perfmon, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Resource Governor, Change Data capture, Management Data Warehouse, Windows Server 2003/2008/2008 R2/2012, Team Foundation Server, Unix, Power shell 2, Erwin, IIS 7.0, SQL Sentry 7.5, IGT 9.1, SBX 4.1, ezPay 9.1, Tournament Manager 2.0, Table Manager 9.1, TwinFin 3, NPS 6.0.5.P2/7.0.P2, 1000 DW Appliance, Cognos, UNICA Campaign 9.0.0.1 and Infogenesis POS, vSphere Client 5.0/5.5, Solar Winds, Microsoft Access 2010, Master Data Services Configuration Manager, Master Data Manager, System Center 2012, Sybase Adaptive Server Enterprise 15.0, Oracle 11g\12c, SQL Server Parallel Data Warehouse(PDW).

Confidential, Boston, MA

Sr. SQL Server DBA/ Architect/BI Developer

Responsibilities:

  • Responsibilities were to perform Monitoring, Performance Tuning, Troubleshooting the issues, Backup and Restores, provide High Availability, Security, Implementing Best practices, Design specifications for the OLTP server, databases, Transactional Replication.
  • Performed Database Migrations from Oracle, Sybase Adaptive Server Enterprise 15.0, MYSQL and DB2 to SQL Server 2008 R2.
  • Provide Support to Marketing applications like DXMark. Creating SSIS Package and scheduling them through SQL Server Jobs.
  • Creating Inventory SQL Server reports using SSRS and Moving to the Service Manager.
  • Upgrading Analysis Services from SQL Server 2008 to SQL Server 2008 R2.
  • Creating KPIs, Dimensions, Attributes, Cubes, Hierarchies, Analysis Services databases, Cubes.
  • Replicated the data between databases using SQData.
  • Created Reports using Microstrategy.Tuned the Cubes.

Environment: SQL Server 2008R2/2008, MS Visual Studio 2008/2010, MS BI Dev. Studio, Enterprise Manager, SSIS, SSAS, SSRS, IIS, Query Analyzer, DMV’s, Vb.NET, MS Visio, SQL Diagnostic Manager, Perfmon, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Resource Governor, Change Data capture, Management Data Warehouse, Windows Server 2008, Team Foundation Server, Unix, Power shell 2, Erwin, IIS 7.0, DXMark, Foglight Performance Analysis for SQL Server, Spotlight on SQL Server Enterprise, ProClarity, SQL Compare 9.0, Citrix, System Center Service Manager 2010, Sybase Adaptive Server Enterprise 15.0,SQData, Microstrategy Analytics, Oracle 11g

Confidential, Wakefield, MA

Sr. SQL Server DBA/ Architect/BI Developer

Responsibilities:

  • Responsibilities were to perform Monitoring, High Availability, Performance Tuning, Troubleshooting the issues, Security, Implementing Best practices, Backup and Restores.
  • Provide Support to Campaigning applications like T1, Siebel Marketing, Siebel web client, Max, SelfScrub, OBIEE, Portfolio Reporting. Creating SSIS Package and scheduling them through SQL Server Jobs. Granting Access to the users in the Analysis Services.
  • Replicated the data between databases using SQData.
  • Created Reports using Microstrategy.

Environment: SQL Server 2008R 2/2008/2005/2000 , MS Visual Studio, MS BI Dev. Studio, Enterprise Manager, SSIS, SSAS, DTS, SSRS, IIS, Query Analyzer, DMV’s, Vb.NET, MS Visio, SQL Diagnostic Manager, Perfmon, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Resource Governor, Change Data capture, Management data warehouse, Windows Server 2008, Team Foundation Server, Unix, Power shell 2, Erwin, Tivolli Workload Scheduler, Data Integrator, T1 3, Siebel Marketing 7.7, Siebel web client 7.7, Max 2, SelfScrub 2, OBIEE 10.1.3.3.2 , Portfolio Reporting, Sun One (Web Server 6.1), AIX( App server webphere 6.1), 3DNS( Automatic Fail over Tool),IIS 6.0,Veritas Backup, Gnuwin 32,SSH tectia, ODBC for teradata, Terradata, SQL Assistant 12.0, Litespeed, Oracle Business Intelligence, Siebel 7.7,Teradata Client 13.10, SAS 9.2,EMC PowerPath, Emilex HBAnywhere, Arcsight SmartConnector, Citrix, Sybase Adaptive Server Enterprise 15.0, SQData, Microstrategy Analytics

Confidential, Edison, NJ

Sr. SQL Server DBA/Oracle DBA/BI Developer

Responsibilities:

  • Responsibilities were to perform Health checks, database tuning, assessments, upgrades, migrations, on-call support, troubleshooting, logical and physical database design, monitoring servers, fine tuning the slow running queries, perform backup and restores, replication and provide High availability.
  • Creating SSIS Package and scheduling them through SQL Server Jobs.

Environment: SQL Server 2008R 2/2008/2005/2000 , MS Visual Studio, MS BI Dev. Studio, Enterprise Manager, SSIS, SSAS, DTS, SSRS, IIS, Query Analyzer, DMV’s, Vb.NET, MS Visio, Litespeed, Perfmon, Spotlight, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Resource Governor, Change Data capture, Management data warehouse, Windows Server 2008 R 2/ 2008/2003/2000 , Team Foundation Server, Unix, Power shell 2, Perl, Oracle 10g R2.

Confidential, Cherry Hill, NJ

Lead SQL Server DBA/Oracle DBA/BI Developer

Responsibilities:

  • The project goal was to provide production support for Foursite, Navitrace, Accuplus, Boomi, TMT Fleet Maintenance, the Dawg, Mechanic Workstation, Shop Planner Applications and mission critical SQL and Oracle databases.
  • Creating SSIS Package and scheduling them through SQL Server Jobs.

Environment: SQL Server 2008R 2/2008/2005/2000 , Windows Server 2008/2003/2000 , MS Visual Studio, MS BI Dev Studio, Enterprise Manager, SSIS, SSAS, DMV’s, DTS, SSRS, Oracle 10g R2, IIS, Query Analyzer, Vb.NET, Crystal Report, MS Visio, Litespeed, Perfmon, LINQ, Spotlight, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Change Director, Numara Track-It 8, Microsoft Visual Source Safe 6, Confidential Query Farm Maintenance, Team Foundation Server, Unix, Power shell 2, Perl.

Hire Now