SUMMARY

• Successful Database Administrator/Developer with 13 years of experience in database development and production environments.
• Certified and Experienced with SQL Server. Experience in Microsoft SQL Server Database Administration, Developing & Implementing Solutions on SQL Server.

TECHNICAL SKILLS

• SQL SERVER Database Administration
• SQL SERVER Database Development
• SSIS
• SSRS
• PowerBI
• T - SQL
• Performance Tuning
• Technical analysis
• PowerShell Scripting
• Product development

PROFESSIONAL EXPERIENCE

Database Manager

Confidential

Responsibilities:

• Design, code and maintain new and existing complex T-SQL stored procedures, triggers and functions
• Liaising with both technical and non-technical stakeholders from C-Level down to gather requirements
• Working with Infrastructure team to Manage Azure Deployment Cost
• Work with clients' Business and IT leaders to define strategic and tactical requirements of the organization to fulfill the business needs
• Line management responsibilities of BI/SQL Developers
• Provide leadership and guidance on all aspects related to data during an implementation project including, but not limited to, Requirements Analysis and design, configuration, development, conversions, system testing, cut over and production support
• Optimize SQL queries, indexes, views, and stored procedures
• Participates in application design and development process with developers
• Recommend and lead implementation for improvements to SQL Server configuration
• Assist development teams in the build out of schema and database technologies
• Oversee all use and administration of the Confidential database, including troubleshooting problems with the database and acting as primary liaison between the regions and the database vendor
• Function as the primary point of contact for all issues and requests relating to the Agency databases and triage/manage issues
• Manage all upgrades and patch installations and new feature implementations
• Work closely with the IT vendor to ensure speedy response times and a high quality of work
• Responsible for Business Continuity with Backup & restore
• Managing the Always on Availability Groups
• Assist development teams in the build out of schema and database technologies
• Ensure use of best practices for data-driven applications within development teams
• Continue to develop skills in database optimization, reporting, data analysis, and other database duties as a member of an agile software team
• Communicate and/or translate business challenges to technical IT staff members and assist in developing solutions
• Work within the Change Management and Configuration Management processes
• Creates & documents maintenance, deployment, and recovery plans
• Contributes code used in automated deployment of applications
• Extracted Sage Timberline data, identifying challenges and proposing development solutions
• Managed data analysis and reporting process for 6 employees
• Supervised and trained staff providing leadership and supportive working environment
• Consulted with IT on advancement of in-house Software built to manage data connectivity between network systems
• Implemented BI solution framework for end-to-end business intelligence projects
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers
• Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process

Confidential

Responsibilities:

• Enforce database quality standards within the code base
• Configured and managed the replication for enterprise databases based on business requirements
• Managed the enterprise databases backups and restore operations to ensure high availability of the data
• Build out and maintain reporting service and integration service applications
• Support transactional and analytical database efforts in support of the business needs
• Respond to data inquiries from client stakeholders and the business team
• Support architecture team in long-term planning and implementation
• Support after-hours and on-call duties as required
• Design, code and maintain new and existing complex T-SQL stored procedures, triggers and functions
• Conducted analysis of departmental, organizational, and individual information needs relative to specific assignments
• Analyzed system performance, data integrity and security requirements in development and resolution work
• Automating data Import/Extraction using SQL Server tools such as SSIS, BCP, bulk insert
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers
• Designed and implemented TSQL queries for reporting and complex solution development

Principal Database Administrator

Confidential

Responsibilities:

• Responsible for Business Continuity with Backup & restore.
• Managing the Database Mirroring and Log Shipping.
• Developed tSQL queries, stored procedures, triggers, user defined functions (UDF), views, indexes, and user defined.
• Data types strictly following the data integrity using constraints, rules, and default.
• Developed CTEs, constraints, and complex queries to fetch the data from different servers.
• Developed processes based on technical specifications and development standards.
• Performed unit testing on all development.
• Cross-trained the team and department members in the support of tools developed.
• Generating SSRS reports which included various reporting features such as groups, subgroups, adjacent-groups, group by total, group by sub-totals, grand-totals, drilldowns, drill through, sub-reports, navigation reports.
• Analyze troubleshoot and remediate data integrity issues.
• Analyzing hardware, software, network ecosystems to optimize database server performance including use of partitions and file layouts on disks.
• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.

Sr. Database Administrator Team Leader

Confidential

Responsibilities:

• Designing and developing the SSIS packages, stored procedures, configuration files, tables,views, indexes.
• Used SSIS to extract data from enterprise data warehouse, Oracle added multiple transformations to transform the data and finally loaded into the DB2 database.
• Using table difference, upsets, lookups, and conditional splits for finding deltas.
• Creating the SSIS jobs for monitoring the jobs that depend on daily loads and loading db2 database tables using SQL server agent.
• Automating tasks using active x script (similar to VB Script).
• Be able to implement failure alerts using email in SSIS.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the staging database.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS worked on data transfer from a text file to SQL server by using bulk insert task in SSIS.
• Created Windows logins and privileges to user accounts/groups and objects.
• Monitored the job performances to ensure processes run according to schedule.
• Troubleshoot and resolved the issues as needed.
• Working with SSIS packages involved FTP tasks, fuzzy grouping, merge and merge join.

Database Administrator

Confidential

Responsibilities:

• Developed tsql with service brokers.
• Performance tuning of SQL queries and stored procedures using SQL profiler.
• Performed server installation and configuration using SQL server.
• Designing, implementing and maintaining the database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, rules, defaults and complex SQL statements.
• Developing the SQL programs and involved in optimize stored procedures and queries for faster retrieval and server efficiency SSAS and SSIS.
• Involving in mock testing and unit testing and integration testing in SSIS.
• Creating the automated stored procedures for day end operations using SQL server agent and CTE.
• Designing and implementing the snapshots report, report subscription, data-driven subscription and report caching using report manager.
• Project Name: ezReview.