Sr SAS Developer & Analyst
Resume:
JAMES WATT
*******@*****.*** 646-***-****
SUMMARY
** ***** ** ** ********** in USA which includes more than Ten years in Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2008/2005/2000/7.0 and 6.5 in Production, Development environments & Replication Environments.
• Experience in working with Windows 2000/2003/2008 Servers and the service packs
• Experience working with Production 24/7 and Development Environments.
• Extensive experience in installation, configuration & Maintenance of MS SQL Server 2008, 2005, 2000
• Experience in Database Backup, Recovery and Disaster Recovery Models.
• Migration from SQL Server 2000 and SQL Server 2005 and 2008.
• Involved in Database Migration from Siebel to SQL Server 2000 and Upgrade to SQL Server 2005/2008
• Database export and import from MS Access 2007 to SQL Server 2008
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Experience in implementing Database Encryption, data collection features in SQL Server 2008
• Hands on experience in writing & debugging Stored Procedures and triggers, Troubleshooting database issues.
• Installation of IIS Server and configuration on Windows 2008 R2 Server.
• Experience in Capacity Planning and documentation of SLAs.
• Experience in third party tools DB Artisan, BrightStor Arcserve up Software, LightSpeed, SQL Safe lite, and Veritas Backup 11.0
• Experience in working on Virtual Machines with SAN
• Experienced in Creating Databases based on Functional Requirements and System Design.
• Experience in assisting the Application Developers in creating conceptual database designs that meet the business and technical objectives of various projects.
• Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Experience in using Performance Monitor/Profiler to solve Dead Locks/Long running queries and performance related issues.
• Experience in supporting Black Board and CAMS Enterprise Software’s used by Educational Institutions
• Experience in working with DTS/SSIS/SSRS/SSAS.
• Worked extensively on setting up SSRS admin as well as developing reports using SQL.
• Extensively used DBCC commands
• Experience in implementing SQL ServerActive/Passive Clustering Environment in SQL Server 2008
• Experience in implementing Log Shipping, Mirroring setup in SQL Server 2008
• Experience in setting up SSRS and SSAS and also worked on report generation
TECHNICAL SKILLS:
Operating Systems : Windows 95/98, Windows NT/2000/2003/2008, MS-DOS, UNIX
RDBMS & Tools : SQL Server 2000/2005/2008, MS Access 2003/2007/2010, Oracle 9x,
MySQL 5.0, Sybase, SQL Loader, Export/Import,
Languages : T-SQL, PL/SQL, C, HTML DB Artisans, VB, .net, C#
Web Systems : IIS 6.0 Web Server, DNS, TCP/IP, Proxy Server , MTS 2.0
Development Tools : Visual Basic 5.0/ 6.0, Visual Interdev 6.0, C#
Reporting Tools : Business Objects XI, SSRS,
HARDWARE : Dell 1300/2300/6300, Sun Solaris, Alpha, SAN, VM Ware, SAN
ETL Tools : Pentaho, SSIS
Third Party Softwares : Black Board, CAMS Enterprise (Used mostly by Colleges)
Backup software’s : Arc Serve 6.61, Seagate, Brightstone
Other Software’s :VPN Central, KBox, ActiveX, DAO, ODBC, ADO, MS Outlook, TOAD, Front Page, SQL, Vi Editor, VPN-1, Telnet, FTP, VPN, Terminal Server
Data Model : Darwin 2.0, Erwin
ACADEMIC QUALIFICATIONS
• BS in Engineering from Nagarjuna University, India
• Post Graduate Diploma in Computer Applications, Central University, India
CERTIFICATION AND TRAINING
Microsoft Certified Professional in Visual Basic
Microsoft Certified Professional in SQL Server 6.5 (Implementation and Design)
Microsoft Certified Professional in SQL Server 7.0/2000 (Administration)
PROFESSIONAL EXPERIENCE
Client: United States Merchant Marine Academy, Kings Point, NY June 2010 to Till Date
Sr. SQL Server DBA
This company has so many applications running which is supported by our DBA team. Being Primary DBA following are my daily responsibilities.
• Installation of SQL Server 2000/2005/2008 and Service Packs on Windows 2003 and 2008R2 Servers
• Involved in Data Migration between MS Access 2003 to SQL Server 2008. Involved extensively on Access Migration projects to SQL Server.
• Involved in setting up Production Development and testing environment with active-passive clustering on Windows 2008R2 Servers.
• Installation of IIS and configuration of IIS servers and setup the CAMS application. Cams application extensively used by educational institutions in USA.
• Involved in setting up Black Board Applications Softwares which are used by Educational Institutions
• Involved in Database migrations from SQL Server 2000 to 2008. And SQL Server 2005 to SQL Server 2008.
• Involved in working with Development and Testing team for database design and development.
• Involved in Installation of Business Objects XI.
• Involved in setting up Windows Clustering and SQL Server clustering.
• Installed and configured 64 Bit SQL Server 2008 active\active cluster instances on SAN Environment
• Installed the SQL server 2008 on brand new hardware according to company standards
• Configured database settings and memory settings and moved the tempdb data files and log files
• Responsible for Maintaining Databases and working with Development team and Testing team.
• Experience in working with SSRS and SSIS in SQL Server 2005/2008.
• Responsible for taking care of Backups and Restore strategies on regular basis.
• Involved in preparation of documentation for Recovery strategies and back up strategies
• Setting up Daily jobs running in the Production Environment and monitoring them on regular basis.
• Expertise in Setting up Failover Technologies.
• Extensively involved in performance monitoring and tuning issues. I also recommended new servers based on my performance analysis data.
• Implemented Log Shipping and Mirroring in our environment in SQL Server 2008.
• Trained our customers and end users about Database concepts.
Client: Americorp, Woodbury, NY May 2008 to May 2010
Sr. SQL Server DBA
Americorp is a Debt Settlement and Debt Management company has been serving many clients in all over USA.
Being Primary DBA following are my daily responsibilities.
• Installation of SQL Server 2000/2005/2008 and Service Packs on Windows 2003 and 2008 Servers
• Installed and configured 64 Bit SQL Server 2008 active\active cluster instances on SAN Environment
• Installed the SQL server 2008 on brand new hardware according to company standards
• Configured database settings and memory settings and moved the tempdb data files and log files
• Responsible for Maintaining Databases and working with Development team and Testing team.
• Experience in SSRS and SSIS in Sql server 2005/2008.
• Responsible for taking care of Backups and Restore strategies on regular basis.
• Involved in preparation of documentation for Recovery strategies and back up strategies
• Setting up Daily jobs running in the Production Environment and monitoring them on regular basis.
• Expertise in Setting up Failover Technologies.
• Extensively involved in performance monitoring and tuning issues. I also recommended new servers based on my performance analysis data.
• Involved in Transaction Replication
• Experience in using Veritas Backup 10.00
• Creating new Login users for Development and Testing team and give them the appropriate permissions for the database level and object level permissions
• Worked on setting up Optimal Configurations. Worked with System Admin team to check to make sure RAID configuration and also SAN configuration are properly done. Spent considerable amount of time on performance issues.
• Used TrackIT software to receive troubleshooting issues.
• 24x7 production call support.
• Working with Development team to help their issues and modifying the stored procedures and triggers
• Data Loading with SSIS, DTS , BCP and Bulk Insert tools
• Maintenance plan for full, differential, Transactional Backup and database recovery with experience of complex recovery scenarios.
• Used SSIS, SSAS Services in SQL Server 2008. Used Copy Database Wizard and other new features extensively in 2005.
• Involved in setting up SSRS and developed reports
• Performed database maintenance including backups/restores and index tuning.
• Involved in training our customers on SQL Server related issues.
Environment: MS SQL Server 2000/2005/2008, SSRS, IIS, MTS, ASP.NET, VB.NET, Windows 2000/2003/2008, VM Ware, SAN, DB Artisan, Veritas Backup 10.0, Business Objects
Client: Affinity Health Plan, Bronx, NY (Affinityplan.org) December 2007 to March 2008
Sr. SQL Server DBA
Affinity Health Plan is an independent, not-for-profit managed care company dedicated to serving the needs of low-income residents of the New York Metropolitan Area. Founded in 1986, Affinity was the first health plan licensed in New York State specifically to serve public sector programs. It served as a model for development of the State Medicaid managed care program, and as a pilot for State subsidized programs for the uninsured. Today, Affinity serves over 200,000 enrollees through its Medicaid, Child Health Plus, Family Health Plus and UniCare programs.
This company has so many applications running which is supported by our DBA team. I have supported 29+ applications and 110 SQL Server Databases
• Installed and configured f SQL Server 2000/2005 and Service Packs on Windows 2000/2003 Servers
• Installed and configured 64 Bit SQL Server 2005 active\active cluster instances.
• Upgrading to SQL Server 2005 Servers from SQL Server 2000
• Working with Development and Testing Team to provide Production Environment
• Worked extensively on DML, DDL statements as well as writing stored procedures and triggers.
• Database Loading through BCP, DTS and SSIS. Loading of large data between the databases
• Setting up DTS Packages and setting up to run DTS packages on regular basis and enhancement of the previously designed packages
• Created and managed databases in production and development servers.
• Worked on Clustering Environment on SAN Environment.
• Exposure to VM Ware Environment. Expertise in managing SQL Servers on Virtual Machines
• Creating new Login users for Development and Testing team and give them the appropriate permissions for the database level and object level permissions
• Extensively worked on Performance Issues for Affinity Production Servers and fixed the performance issues.
• Worked on setting up Optimal Configurations. Worked with System Admin team to check to make sure RAID configuration and also SAN configuration are properly done
• Used FOOTPRINT software to receive troubleshooting issues.
• 24x7 production support. Used VPN client to support from home during weekends.
• Working with Development team to help their issues and modifying the stored procedures and triggers
• Data Loading with SSIS, DTS , BCP and Bulk Insert tools
• Maintenance plan for full, differential, Transactional Backup and database recovery with experience of complex recovery scenarios.
• Used SSIS, SSAS Services in SQL Server 2005. Used Copy Database Wizard and other new features extensively in 2005.
• Responsible in managing Transaction Replication
• Worked with Active/Passive Clustering Environment
• Experience in handling 4 TB size of Data
• Escalated critical issues regarding production servers to Microsoft
• Scheduling Back ups and checking the Back ups on regular basis
• Disk Capacity Planning and recommendation. Optimum Configuration recommendations to the Production Servers
• Preparation of documentation for Data Migration between the servers
Environment: MS SQL Server 2000/2005, IIS, MTS, ASP.NET, VB.NET, Windows 2000/2003, VM Ware, SAN, DB Artisan, Brightstor Arcserve Backup
Client: MTA, LIBUS, Garden City, Long Island November 2006 to October 2007
Lead SQL Server DBA
Primary Responsibilities are:
• Database Migration from SQL Server 6.5 to SQL Server 2000 and Upgrade to SQL Server 2005.
• Moving data between MS Access Database and SQL Server Databases.
• Installation of SQL Server 7.0/2000/2005 and Service Packs on Windows 2000 Servers
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Worked extensively on DML, DDL statements as well as writing stored procedures and triggers.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Database Import and export between MS Access 2000 to SQL Server 2000
• Working with Development team to help their issues and modifying the stored procedures and triggers
• Data Loading with DTS , BCP and Bulk Insert tools
• Maintenance plan for full, differential, Transactional Backup and database recovery with experience of complex recovery scenarios.
• Experience in handling 800 GB size of Databases
• Working with the development team to create stored procedures and triggers
• Scheduling Back ups and checking the Back ups on regular basis
• Setting up DTS packages and schedule them on regular basis
• Disk Capacity Planning and recommendation. Optimum Configuration recommendations to the Production Servers
• Preparation of documentation for Data Migration between the servers
Environment: MS SQL Server 7.0/2000/2005, IIS, MTS, VB.NET, Windows 2000/2003. MS Access 97/ 2000
Client: Greenwich Information Services, , North Dakota, June 2006 to October 2006
Sr. SQL Server DBA (Team Lead)
• Database Migration from Siebel Databases to SQL Server 7.0 and Upgrade to SQL Sever 2000 and SQL Server 2005. Working with Siebel team at the client site to work with the Data Migration.
• Installation of SQL Server 2000/2005 and Service Packs
• Database Import and export between MS Access 2000 to SQL Server 2000
• Database Loading from Siebel to SQL Server using EIM
• Data Loading with DTS , BCP and Bulk Insert tools
• Database monitoring and performance tuning using Performance Monitor
• Designed DTS Package, DTS Import/Export for transferring data from .cvs files into SQL Server 2000
• Creating users and their permissions
• Installation of Windows 2000 and Windows 2003 servers and setting up configuration
• Working with the Development and testing team to test the servers and their performance through Performance Monitor and SQL Trace. Set up SQL Trace for Production Environment
• Setting up of Transaction Replication and administration
• Working with the development team to create stored procedures and triggers
• Worked extensively on Back up strategies and documentation
• Setting up Clustering Environment
• Setting up DTS packages and schedule them on regular basis
• Disk Capacity Planning and recommendation. Optimum Configuration recommendations to the clients
Environment: MS SQL Server 2000/2005, IIS, MTS, VB.NET, Windows 2000/2003, MS Access 97/2000, UNIX, Oracle 9i, Arc Serv, Crystal Reports, Siebel
Citi Bank, New York May 2004 to May 2006
Sr. SQL Server DBA
Responsibilities
• Effectively interacted with Business analyst, technical leads & architects, system sponsors and users to understand the business requirements, system specifications.
• Designed data models (ER Model & Dimensional data models) to support OLTP applications. Successfully performed physical data base design.
• Re-engineered existing data models and data structures. Extensively worked and successfully implemented SQL Server 2000. Extensively worked with new features such as Table/Index partitioning, Database Mirroring
• Responsible for disk configuration, data file and file group planning, space management
• Installation & Configuration of SQL Server 2005/2000 Enterprise Edition on new DELL Servers. Installed and configured Microsoft IIS & MTS servers.
• Involved in Up gradation of SQL Server 2000
• Responsible for capacity planning, resource management such memory management, disk management etc. also responsible for back up, recovery and disaster recovery.
• Involved in Transaction Replication
• Weekly and daily performance monitoring. Responsible for Data base fine tuning, query optimization, including Query execution plans, SQL Profiler traces, and indexing strategies, Troubleshooting, Transactions and locking issues
• Extensively worked with DTS (Data Transformation Services), BCP, Migration and transformation of data to different SQL Servers
• Perform Capacity Monitoring and short and long-term capacity planning in collaboration with development resources, System Administrators and System Architects.
• Automated processes using SQL Server jobs. Proper use of Views to prevent unauthorized access.
• Designed DTS Package, DTS Import/Export for transferring data from .cvs files into SQL Server 2000
• Executing Database Consistency Checks on routine basis, Placement of Primary & Secondary file groups on partitioned drives for faster access of data
• Working with the Development team for their requirement of T-SQL queries
• Responsible for creating, altering Indexes and testing them to ensure performance of system
• Creation and management of constraints, indexes, stored procedures, trigger and views, Migration of development databases to production Servers
• Developed complex stored procedures to perform ETL tasks to load data warehouse
• Created FTP and various batch files.
• Recommendation and implementation of new system
• 24 X 7 production support.
Environment: MS SQL Server 2000/2005, IIS, MTS, VB.NET, Windows 2000/2003. UNIX, Oracle 9i, Arc Serv Backup Software, Crystal Reports
Stickeley, Syracuse, New York April 2003 to April 2004
SQL Server DBA
Responsibilities
• Effectively interacted with Business analyst, technical leads & architects, system sponsors and users to understand the business requirements, system specifications.
• Installation of Windows NT/2000 and MS Exchange Servers and installation of service packs and security patches. Setting up user accounts and configuring TCP/IP and creation of DSN.
• Back up and Recovery and setting up Windows NT Performance Monitor
• Installation and upgrade of SQL Server 7.0 and 2000 and service pack
• Designed data models (ER Model & Dimensional data models) to support OLTP applications. Successfully performed physical data base design.
• Responsible for disk configuration, data file and file group planning, space management
• Installation & Configuration of SQL Server 2000 Enterprise Edition on new DELL Servers. Installed and configured Microsoft IIS & MTS servers
• Responsible for capacity planning, resource management such memory management, disk management etc. also responsible for back up, recovery and disaster recovery.
• Involved in Transaction Replication
• Weekly and daily performance monitoring. Responsible for Data base fine tuning, query optimization, including Query execution plans, SQL Profiler traces, and indexing strategies, Troubleshooting, Transactions and locking issues
• Extensively worked with DTS (Data Transformation Services), BCP, and SQL Server Import/Export Utilities. Migration and transformation of data to different SQL Server
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Helping the development and the QA team with fresh data twice everyday with fresh build.
• Executing Database Consistency Checks on routine basis, Placement of Primary & Secondary file groups on partitioned drives for faster access of data
• Responsible for creating, altering Indexes and testing them to ensure performance of system
• Creation and management of constraints, indexes, stored procedures, trigger and views, Migration of development databases to production Servers
• Developed complex stored procedures to perform ETL tasks to load data warehouse
• Created FTP and various batch files.
• Installation of ADOs, and configuration of ODBC, creation of DSN for the client work stations
• Recommendation and implementation of new system
• 24 X 7 production support.
Environment: MS SQL Server 2000/7.0, MS Access 97, IIS, MTS, VB.NET, , Windows 2000, UNIX, Oracle 9i, Arc Serve, Crystal Reports
Clear Blue Technologies, Syracuse, NY December 2000 to March 2003
SQL Server DBA
Here are our few clients I provided DBA Services and 24 hours Support
Assessment Solutions
NewEraCap
UPS (Clustering Enviornment)
Oneida
Fa Davis-Prod
Gates Millennium
MONY (Mutual of New Work)
HSBC
Maintained more than 125 MSSQL Databases with various clients and Pre-Prod and Production environments
.
• Responsible for creation of database device, databases, logical, and physical design of the database both in MSSQL & Sybase Servers and also on Erwin for data modeling
• Involved in Migration of Microsoft SQL Server 6.5 to 7.0
• Responsible for handling over 150 GB of production data
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults
• Creation of New NT Logins and granting privileges to users/Groups and objects
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes
• Backup and recovery of Master, MSDB and Application databases
• Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current
• Responsible for Query optimization and Performance tuning
• Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications
• Worked extensively on DTS Package designs for Import/Export from various Data Source Flat file, Excel, MS Access to MS SQL Server and schedule the jobs in SQL Server
• Provided 24 X 7 support to all Production QA & Development MS SQL Servers
• Responsible for scripting, transfer, backup and restoration of databases
• Worked on SQL Backtrack and Wrote scripts for maintenance of Servers.
• Implemented database cluster for the SQL database.
• Configured replication server in MS SQL to support the high availability needs of the core applications.
• Helped developers to write complex stored procedures
• Provided and implemented recommendations for effective data management.
• Supported 24x7x365 Environment & on call Basis (Production Support)
Environment: Windows 2000, Windows NT, SQL Server 7.0, SQL Server 2000, MS Access, Crystal Reports, Arc Serv, Erwin, MTS, IIS
MySQL Database Administration
My responsibilities includes:
• Installation of Mysql on NT and Unix operating systems
• Creation of databases, tables, views
• Creation and modification of objects
• Loading data into a table
• Table backup and Database backup
• Restoring a table and also database
• Installing MyODBC and configuring MYODBC
Gaylord Information Systems , Liverpool, NY May ‘99 to December 2000
MS SQL Server Database Administration
Gaylord Brothers is a leading Library supplies Organization existing for the last more than 120 years in USA Developed various software products for the Libraries to automate their system.
Responsibilities:
• Installed SQL Server 6.5/7.0 on windows NT/2000, applied service packs and security fixes.
• Database Up gradation from MS SQL Server 6.5 to SQL Server 7.0
• Involved in Disk Capacity Planning and recommendation of the optimum configuration
• Created logical and physical data modeling for development database using Erwin Tool.
• Configured the database maintenance plans for database optimization.
• Experienced in performance tuning using windows performance monitor and SQL Performance Monitor SQL Profiler
• Creating the users, user groups and maintains the access permissions.
• Configured and maintained transactional and merge replication for 2 environments.
• Configured SQL Security features and maintained the user administration.
• Configured IIS Server to work with SQL Server.
• Configured Replication methods like snapshot replication, transactional replication.
• Worked on DTS packages for transferring data from various data sources like Oracle, MS Access, Excel, .Txt file, *.CSV files.
• Worked with developers to tune the queries, run scripts and move the database from production to development Servers.
• Extensive experience working with DTS and BCP tools for loading data
• Setting up database back up and recovery procedures for production, quality and development Servers.
• Troubleshooting client issues ranging from improper configuration settings or data corruption to issues in underlying code; working with product management to provide enhancement or other resolution.
• Managed complex data migrations and upgrades; writing base configuration scripts to validate migration integrity of migration.
• Responsible for monitoring and tuning MS SQL Server performance and ensuring data integrity.
• Successfully maintained multiple sales databases operated by thousands of internal customers and vendors
• Supporting Customer Service department requests by writing queries to document current issues and resolve outstanding tickets.
• Developing triggers, stored procedures and enforcing business rules via checks and constraints.
Participated in project team activities prior to release and contributes to documentation requirements consistent with methodology.
Environment: MS SQL Server 7.0/6.5, DTS, BCP, T-SQL, IIS, ERWIN 3.5.5, Crystal Reports 6.5, MS Access, Windows NT 4.0, Windows 2000, MTS 2.0
Mecon Limited, India (An ISO 9001 company. One of the Largest Consultancy Organization in Asia.)
SQL Server DBA/Programmer Jan 1995 to March 1999
Environment: SQL Server 6.0/6.5, Windows NT, MS Access
Responsibilities Include:
• Create tables, views, databases using SQL Server Enterprise Manager
• Writing stored procedures and triggers
• Creation of users and assign the permissions depends on their role
• Installation of SQL Server 6.5 on Windows Platform
• Responsible for Back up recovery on regular basis
• Extensive involvement in Performance Monitor tool to monitor the servers
• Tuned the database to perform efficiently by managing databases
• Monitor the size of the transaction log. Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Working with the development team to help them to solve their database related tasks
• Worked on data import and Export utility, for transferring data. By using BCP command line utility.
• Work in tune with strategic planning for improving the mapping and data migration.
• Login authentication and permission validation. Create SQL Server Database users and roles.
• Windows NT configuration setup
• Managing Server facilities
• Managing NT User accounts
• Managing Disk Administration and Managing file systems
• Managing Windows NT backups
• Installing TCP/IP and TCP/IP configuration
• Used NT Performance monitor tool
• Used Windows NT scripting language for creating scheduled tasks.
REFERENCES
Furnished upon request
Contact this candidate