We provide IT Staff Augmentation Services!

Database Administrator \ Developer Resume

Atlanta, GA

SUMMARY:

  • Over 13 Years of IT experience which includes over six years of experience in System Analysis and Design, Development, Support & DBA of MS SQL Servers 2016, 2014, 2012 2008, 2005 and 2000 on Windows 2003/NT 4.0 in Production, QA and Development Environments.
  • Flexible, enthusiastic and project - oriented team player with excellent communication and leadership skills to develop creative solution for challenging client needs
  • Ability to adapt quickly to changing environments.
  • Extensive Experience in MS SQL Server 2016, 2014, 2012, 2008 R2/2005 and 2000 Database Administration including Planning, Installation, Deployment/Implementation and configuration on Windows and UNIX plat forms.
  • Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers
  • Developed and Optimized Stored Procedures and Functions using T-SQL
  • Participated in several projects and interacted with peers
  • Gathered business requirements and converted it into SQL stored procedures for database specific projects
  • Installing and Configuring Reporting Services on Clustered Environment for High Availability
  • Experience in Migration of MS SQL Server 2000 to MS SQL Server 2005, MS SQL Server 2005 to MS SQL Server 2008 R2, MS SQL Server 2008 to MS SQL Server 2012 and MS SQL Server 2008 to MS SQL Server 2014.
  • Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client.
  • Extensive experience in Installation, Configuration and Upgrading of MS SQL Server (Including SSIS and SSRS), Client Software and related products for Production, Development and Test Environment.
  • Hands-on experience in Planning, Designing and Developing databases, data warehouses, data marts and OLAP servers.
  • Actively participated in gathering business requirements and system specifications from users.
  • Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
  • Developed full scale Entity Relationship model for all MS SQL backend application
  • Have an extensive experience in Transact-SQL (DDL, DML, and DCL) and with normalized and de-normalized databases.
  • Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
  • Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on).
  • Experience with tools like SQL Server management studio and SQL Server 2005/2008/2012/2014.
  • Experience with Star and Snowflake Schema modeling.
  • Proficient in developing Parameterized, Ad-Hoc Reporting, Linked Reports, Drill down and Drill through reports.
  • Create/Edit/Maintain/implement ETL processes utilizing Microsoft SQL Server Integration Services (SSIS) from a diversity of data sources including other servers, flat files, MS Access, Excel, DB2, Teradata, MYSQL and ORACLE.
  • Worked on development of SSRS and SSAS extensively.
  • Developed custom site templates
  • Developed custom web parts and workflows
  • Implemented Document Management using features such as Site Columns, Security, and Versioning.
  • Created and modified Master Pages and Content Pages in SP Designer 2007.
  • Created and customized Sub Sites, Team Sites, Blogs and Alerts based on company needs.
  • Configured Search Scopes and Excel Services in SSP.
  • Developed workflows for approval of pages before being published to different languages in SharePoint 2010.
  • Created custom menu items as C# features to move list and document library items to different folders according to their lifecycle state.
  • Customized and configured site pages to target content to specific users.
  • Performed and automated SQL Server version upgrades and patch installs.
  • Created browser compatible forms using InfoPath 2010 and deployed to Form Library in SharePoint Sites.
  • Created various custom web parts using Visual Studio.NET that could be plugged in by users into their Personal Site.
  • Working knowledge of Informatica.
  • Working knowledge of Business Objects.
  • Created MS Access databases to collect data systems in order to provide lists, status reports and management overview reports.
  • Managed all data related aspects of multiple directory projects through various stages of production.
  • Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
  • Hands-on experience on deployment of SSIS and SSRS.
  • Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients
  • Experience in configuring Agent Jobs, Sending Alerts using SQL Mail.
  • Designed Maintenance plans. Scheduled and monitored all maintenance activities including database consistency check, index de fragmentation and Updating stats.
  • Extensive Knowledge with FTP, SFTP, Telnet, uploading, software development life cycle.
  • Expertise in Data processing using SSIS, T-SQL and BCP.
  • Extensive experience in space allocation, database migrations and database security.
  • Extensive experience in writing Complex Stored procedures as well analyzing and debugging existing complex stored procedures.
  • Worked on Qlick View to generate drill down reports and complex dash boards to give the flexibility to top management to make the decision.
  • Extensive experience in multiple instances on single server, share memory, design and implementation.
  • Expertise in MS SQL Server databases backup/restore, Disaster recovery strategies of VLDB using VERITAS Net backup and Tivoli.
  • Worked on, implementing XML Schemas, Indexes
  • Creating, Retrieving and Shredding XML Data | XQuery
  • Successfully led, executed and maintained projects with multiple databases.
  • Extensive experience in Capacity planning, Performance Tuning and troubleshooting.

TECHNICAL SKILLS:

Languages: T-SQL, ASP.NET, VB6.0, VB.NET, C#.NET, ASP, JavaScript, VBScript, XML, COBOL, JCL, DB2, VSAM

Databases: MS SQL Server 2016, 2014, 2012, 2008, 2005, 2000, Oracle and MS-Access

Reporting: SSRS, Qlik View, Business Objects

Operating Systems: Windows Server 2012, 2008, 2003, 2000, Advanced Server, Windows NT 4.0/3.51, Windows 3.x and Windows 9.x

Other Tools: MS OLAP, Crystal Reports, ERWIN 3.0, DTS, SSIS, ETL, Performance Manager, IIS, Visual Interdev 6.0, MS OFFICE 2000 and Microsoft Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Database Administrator \ Developer

Responsibilities:

  • Installing, configuring and administering Microsoft SQL Server versions 2005, 2008, 2012, 2014 and 2016.
  • Involved in various stages like System Analysis, Design and Development and deployment.
  • Plan, design, and implement application database code objects, such as stored procedures and views.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Provide database coding to support business applications using T-SQL.
  • Perform quality assurance and testing of SQL server environment.
  • Develop new processes to facilitate import and normalization, including data file for counterparties.
  • Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
  • Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.
  • Designed and developed SSIS Packages (ETL) to transform the data from transactional database to enterprise data warehouse and from data warehouse to data mart.
  • Extracted large volumes of data from various data sources like Teradata, DB2, Oracle, Excel, XML etc. and loaded the data into target data sources by performing different kinds of transformations using SSIS.
  • Configured Audit at each level of the SSIS package for reporting any errors during the execution process of the package/code and for historical tracking of the errors occurred in the SSIS execution process.
  • Designed SSIS Packages to import the data from external sources and different file formats to load in to SQL Server using ftp and sftp.
  • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
  • Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
  • Administrator of the SharePoint/Exchange/Office365 environment
  • Implemented Hybrid SharePoint 2016 environment on Windows Azure platform.
  • Broad use of Agile Scrum industry best practices
  • Create new web applications and site collections, as well as, modifying existing ones.
  • PowerPivot Application Experience with workflows & form design using Microsoft InfoPath.
  • Experience configuring and troubleshooting SharePoint security groups, permissions, and settings.
  • Ability to evaluate and solve complex problems, analyze situations accurately, and implement effective solutions to issues.
  • Deploy and Administrate SharePoint server farms based on Microsoft best practices for Installation, Implementation & Maintenance, Database, and Troubleshooting including IIS configuration.
  • Supported all production operation activities, with focus on integration and development of new and existing products and services.
  • Liaised with project management and development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information.
  • Assisted new and existing clients with integration and data conversion activities.
  • Identified data issues and provided recommendations for resolution to ensure optimal performance.
  • Aided in development, execution, and maintenance of disaster recovery plans for all data services.
  • Worked with internal clients for import and normalization of third-party data.
  • Documented and maintained database system specifications, diagrams, and connectivity charts.
  • Monitored and provided front-line support of daily processes.
  • Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
  • Enhancing the existing databases and database modeling.
  • Worked on, implementing XML Schemas, Indexes
  • Creating, Retrieving and Shredding XML Data | XQuery
  • Actively involved in the data aggregation, data auditing and generating the reports for clients.
  • Worked extensively on huge enterprise level data warehouse and data mart.
  • Created an MS Access database to collect data systems in order to provide lists, status reports and management overview reports.
  • Managed all data related aspects of multiple directory projects through various stages of production.
  • Installed, Configured, Designed and created reports using SSRS.
  • Develop reports using Qlik View reporting tool to drill down the data and dash boards in to various stages,
  • Involved in migrating from SQL Server 2008 to SQL Server 2012 and SQL Server 2008 to SQL Server 2014.
  • Performance Tuning: Analyze, tuning and optimizing SQL Server Applications by using performance monitor and profiler. Assist the SQL Developers in SQL tuning.
  • Performed T-SQL and tuning optimization of queries for reports that take longer execution time using Estimated Execution Plan, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008/2012.
  • Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost. Analyzed different scripts to find the bottlenecks in SQL code
  • Worked on database maintenance, planning and scheduling maintenance jobs such as database consistency check, index de fragmentation and Update stats.
  • Worked in a large team using Microsoft Visual studio 2008 Team System for Database Professionals with TFS for version control and greater co-ordination.
  • Planned and managed backup and recovery strategies.
  • Security Implementation. Administering the MS SQL server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
  • Configured Database Mail and Operator for agent job alerts on Success/Fail/Complete.
  • Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
  • Scheduling Transaction Log Backup and Full backups for disaster recovery and physical space management.
  • Involved in Log Shipping
  • Refreshing Dev and staging servers with production data by restoration of databases for constant synchronization of Dev and staging servers with production servers.
  • Planning, Designing and Developing databases, data warehouses, data marts and OLAP servers. Optimization, clustering, fault tolerance etc.
  • Work on support tickets, maintenance tasks and assigned projects at discretion of the Reporting Coordinator.
  • Monitoring the database: Develop and maintain Master copies of the monitoring, start, stop, backup, export, etc. Monitor & maintain as necessary the following: Alert logs for databases, backups, database connection availability and database process count, exports & their backups, and space in SQL server data file systems.

Environment: SQL Server 2012/ 2008/2005/2000, WINDOWS 2008/2003, SSRS, Qlik View, SSIS NT 4, ASP.NET, VB.NET, C#, Visio, EXCEL, WORD, MS Access, Visual Studio 2008/2005 with TFS\SVN, Informatica, Business Objects,, Erwin and Visio, SP Designer 2016, SharePoint 2016, InfoPath 2013, JIRA.

Confidential, Atlanta, GA

Database Administrator\Developer

Responsibilities:

  • I have completed this recent assignment to consolidate the applications and the servers for a large police department.
  • During this assignment we have upgraded the Police operating environment from Windows NT and 2000 to Windows 2008 servers, MS SQL Server 2000 to MS SQL Server 2008, MS SQL Server 2008 to MS SQL Server 2012 and .net framework 2.5 to Framework 4.0. We have successfully consolidated\merged more than 46 SQL servers into 16 servers thereby reducing the management and maintenance overhead for the servers.
  • We implemented some of the techniques such as failover and load balancing clusters and redundant SAN environments providing the police with high availability and faster response times.
  • In fact we have achieved 3 seconds response time for one of the critical systems which used to be 2 minutes prior to this project.
Confidential

Computer Aided Dispatch

Responsibilities:

  • Installing, configuring and administering Microsoft SQL Servers.
  • Support multiple SQL Server 2000 / 2005 / 2008 R2/2012 databases in both clustered and non-clustered environments with replication/SSIS. Troubleshoot issues within a clustered server configuration.
  • Involved in various stages like development, system Analysis and design
  • Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
  • Database Migration from MS SQL 2000 to MS SQL 2008 and from MS SQL 2008 to MS SQL 2012.
  • Worked on critical enhancements and bugs in PATS application.
  • Redesign the DB to accommodate critical bugs and enhancements.
  • Integrated permits division (Premisys ID) with PATS.
  • Worked on migration of Crystal Reports server from Crystal Reports XI to Crystal Reports 2008 to
  • Performance Tuning: Analyzing, tuning and optimizing SQL Server Applications by using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
  • Assist the SQL Developers to normalize the database and optimize Queries.
  • Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
  • Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
  • Tested applications for performance, data integrity and validation issues.
  • Monitoring the database: Develop and maintain Master copies of the monitoring, start, stop, backup, export, etc. Monitor & maintain as necessary the following: Alert logs for databases, backups, database connection availability and database process count, exports & their backups, and space in SQL server data file systems.
  • Worked on SVN (Source control software) and migrated all the DB scripts for versioning.
  • Security Implementation. Administering the MS SQL server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
  • Worked extensively on Database Mail configuration and mail alert setup on SQL Agent jobs.
  • Designed and implemented Data Warehouse and data marts for the reporting.
  • Created SSIS Packages to import and export data from Excel Spreadsheets, Text files, CSV files, Oracle and DB2
  • Designed, developed and implemented several SSIS packages (ETL) to copy the data from transactional DB to the DW.
  • Develop reports using SQL Server Reporting Services (SSRS) and utilizing complex SQL queries and stored procedures.
  • Configuring, Monitoring and Troubleshooting DB mirroring Replication, Log shipping.
  • Migration and Disaster Recovery plans and Implementation.
  • Planning and implementation of database backup/restore Strategies.
  • Performance Monitoring of MS SQL Server 2005/2000 using various tools like SSMS, Performance Analysis, Spotlight, BMC - Proactisvenet, SQL Sentry, Redgate and Idera.
  • Identified and resolved SQL Server Database locks and hardware-related issues, using Dynamic Management Views & Functions, Server-Side Tracing/Wait-States and database engine and my own strong set of scripts, DMVs, etc., where necessary, to resolve Performance slow-downs due to locking, blocking and other index related issues.
  • Reconfigure/improvements for SQL Server environments, architecture and processes. Experience in performing large scale SQL Server version upgrades.
  • Designed Daily Database Report which is embedded with HTML and send out an email notification with the information every day on the activities and state of the database like data file size and the data file % full, log file size and the log % full, free space on all the drives on the server (virtual\physical), errors\exceptions in past 24 hours.
  • Analyzing the server performance metrics of the server from various tools like VMware and Performance monitor.

Environment: SQL Server 2012/ 2008/2005/2000, WINDOWS 2008/2003,SSRS,SSIS NT 4, ASP.NET, VB.NET, C#, Visio, EXCEL, WORD, MS Access, Visual Studio 2008/2005 with TFS\SVN, Informatica.

Confidential, Washington DC

MS SQL Server Database Administrator\Developer

Responsibilities:

  • Installing, configuring and administering Microsoft SQL Servers.
  • Involved in various stages like development, system Analysis and design
  • Planning, Designing and Developing databases, data warehouses, data marts and OLAP servers.
  • Enhancing the existing databases and database modeling.
  • Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
  • Actively involved in the data aggregation, data auditing and generating the reports for clients.
  • Worked extensively on huge enterprise level data warehouse and data mart.
  • Designed and developed SSIS Packages (ETL) to transform the data from transactional database to enterprise data warehouse and from data warehouse to data mart.
  • Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SSIS.
  • Configured Audit at each level of the SSIS package for reporting any errors during the execution process of the package/code and for historical tracking of the errors occurred in the SSIS execution process.
  • Designed SSIS Packages to import the data from external sources and different file formats to load in to SQL Server using ftp and sftp.
  • Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.
  • Involved in migrating from SQL Server 2005 to SQL Server 2008.
  • Installed, Configured, Designed and created reports using SSRS.
  • Performance Tuning: Analyze, tuning and optimizing SQL Server Applications by using performance monitor and profiler. Assist the SQL Developers in SQL tuning.
  • Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost. Analyzed different scripts to find the bottlenecks in SQL code
  • Worked on database maintenance, planning and scheduling maintenance jobs such as database consistency check, index de fragmentation and Updating stats.
  • Planned and managed backup and recovery strategies.
  • Configured Database Mail and Operator for agent job alerts on Success/Fail/Complete.
  • Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers
  • Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
  • Scheduling Transaction Log Backup and Full backups for disaster recovery and physical space management.
  • Involved in Log Shipping
  • Refreshing dev and staging servers with production data by restoration of databases for constant synchronization of dev and staging servers with production servers.
  • Monitoring the database: Develop and maintain Master copies of the monitoring, start, stop, backup, export, etc. Monitor & maintain as necessary the following: Alert logs for databases, backups, database connection availability and database process count, exports & their backups, and space in SQL server data file systems.
  • Providing 24x7 On-Call support for production applications.

Environment: SQL Server 2008/2005/2000, WINDOWS 2008/2003, NT 4, ASP.NET, VB.NET, C#, Visio, EXCEL, WORD, MS Access, Visual Studio 2008/2005 with TFS.

Confidential, Bethesda, MD

Database Administrator\Developer

Responsibilities:

  • Installing, configuring and administering Microsoft SQL Servers.
  • Involved in various stages like development, system Analysis, design.
  • Planning, Designing and Developing databases, data warehouses and OLAP servers. Optimization, clustering, fault tolerance etc.
  • Research with team members and came up with the high level design, impact analysis document with several solutions to the problem during implementation proposed new system.
  • Enhancing the existing databases and database modeling.
  • Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
  • Developed custom site templates
  • Developed custom web parts and workflows
  • Implemented Document Management using features such as Site Columns, Security, and Versioning.
  • Created and modified Master Pages and Content Pages in SP Designer 2007.
  • Created and customized Sub Sites, Team Sites, Blogs and Alerts based on company needs.
  • Configured Search Scopes and Excel Services in SSP.
  • Developed workflows for approval of pages before being published to different languages in SharePoint 2010.
  • Created custom menu items as C# features to move list and document library items to different folders according to their lifecycle state.
  • Customized and configured site pages to target content to specific users.
  • Created browser compatible forms using InfoPath 2010 and deployed to Form Library in SharePoint Sites.
  • Created various custom web parts using Visual Studio.NET that could be plugged in by users into their Personal Site.
  • Support for ongoing huge databases.
  • Scheduled and monitored all maintenance activities including database consistency check, index de fragmentation and Updating stats.
  • Involved in migrating from SQL Server 2005 to SQL Server 2008.
  • Extensively used SSIS to Export/Import data from existing database to live database and Vice-versa.
  • Created SSIS packages to transfer objects from development server to production.
  • Used SSRS extensively to create reports.
  • Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
  • Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
  • Database and Log Backups and restoration, backup strategies, scheduling backups.
  • Setup and maintained Linked Servers.
  • Worked extensively on Database Mail configuration and mail alert setup on SQL Agent jobs.
  • Security Implementation. Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
  • Testing of applications for performance, data Integrity.
  • Actively involved in Transforming Operational Data and planning Data Warehouse design.
  • Involved in Managing a Data Warehouse or Data Mart.
  • Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
  • Database and Log Backups and restoration, backup strategies, scheduling backups.
  • Managing the use of disk space, memory and connections. Running DBCC.
  • Worked in a large team using Microsoft Visual studio 2005\2008 Team System for Database Professionals with TFS for version control and greater co-ordination.
  • Providing 24x7 on-call technical support.

Environment: SQL Server 2008/2005/ 2000, Oracle 10g,Toad for Oracle, WINDOWS 2003/2000, NT 4, ASP.NET, VB.NET, C#, Visio, EXCEL, WORD, MS Access, Visual Studio 2008/2005 with TFS, SP Designer 2007, SharePoint 2010, InfoPath 2010.

Confidential, Alexandria, VA

Database Administrator\Developer

Responsibilities:

  • Involved in various stages like development, system Analysis and design.
  • Actively participated and interacted with users, team members, leads and technical manager of concerned system to fully understand the business rule and requirements of the changes that need to be made compatible with existing system.
  • Analyzed different tables from all customer line, figured out the natural keys for each table if it had any, and came up with the business rule to whether insert only new records or insert all records or merge duplicate records. These tables were assigned as per clients.
  • Created several SSIS packages to import Flat files (CSV) into data tables. These packages were scheduled in regular time interval.
  • Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost. Analyzed different scripts to find the bottlenecks in SQL code
  • Wrote several SQL scripts in order to have required check constraints, Indexes, and Views as per existing Business Rules. Also Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Wrote scripts to check for duplicate records and delete/modify them on this staging table depending on the business rule.
  • Worked in a large team using Microsoft Visual studio 2005 Team System for Database Professionals with TFS for version control and greater co-ordination.
  • Regularly monitored the system for bottlenecks of H/W (CPU, RAM, Disk IO and networking) and Software version, Maintained database and Backup/recovery. Defined Database Maintenance Plan which was scheduled as job and made them run automatically.
  • Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
  • Worked extensively on SSRS and Crystal Reports to create reports.
  • Worked Extensively on VBA.
  • Setup and Maintained Snapshot Replication across multiple server environments.
  • Setup and maintained Linked Servers.
  • Actively involved in migrating from SQL Server 2005 to SQL Server 2008.
  • Monitoring the database: Develop and maintain Master copies of the monitoring, start, stop, backup, export, etc. used on IPN supported machines. Monitor & maintain as necessary the following: Alert logs for databases, backups, database connection availability and database process count, exports & their backups, and space in SQL server data file systems.
  • Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDFs, indexes rules and defaults on MS SQL server.
  • Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
  • Security Implementation. Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
  • Testing of applications for performance, data Integrity.
  • Actively involved in migrating from SQL Server 2000 to SQL Server 2005.
  • Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
  • Managing the use of disk space, memory and connections. Running DBCC.

Environment: SQL Server 2008/2005/ 2000, WINDOWS 2003/2000, NT 4, ASP.NET, VB.NET, C#, Visio, EXCEL, WORD, MS Access, Visual Studio 2008/2005 with TFS

Confidential, Richfield, OH

Database Administrator/Developer

Responsibilities:

  • Involved in various stages like development, system Analysis, design.
  • Worked on Microsoft Visual studio 2005 Team System for Database Professionals with TFS for version control and greater co-ordination.
  • Enhancing the existing databases and database modeling.
  • Extensively used DTS and SSIS (ETL).
  • Created SSIS packages to transfer objects from development server to production.
  • Worked extensively on SSRS to create reports.
  • Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
  • Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
  • Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
  • Setup and Maintained Snapshot Replication across multiple server environments.
  • Setup and maintained Linked Servers.
  • Worked extensively on Database Mail configuration and mail alert setup on SQL Agent jobs.
  • Security Implementation. Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
  • Testing of applications for performance, data Integrity.
  • Actively involved in Transforming Operational Data and planning Data Warehouse design.
  • Involved in Managing a Data Warehouse or Data Mart.
  • Actively involved in migrating from SQL Serer 2000 to SQL Server 2005.
  • Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
  • Database and Log Backups and restoration, backup strategies, scheduling backups.
  • Managing the use of disk space, memory and connections. Running DBCC.

Environment: SQL Server 2005/ 2000, WINDOWS 2003/2000, NT 4, ASP.NET, VB.NET, C#, Visio, EXCEL, WORD, MS Access, Visual Studio 2005 with TFS

Hire Now