Consultant Sql Server Dba Resume
3.00/5 (Submit Your Rating)
SUMMARY
- 25+ years of professional experience in all stages of SDLC (Software Development Life Cycle) involving studying of the user requirements, analyzing, designing, coding, implementation, debugging, testing, deployment and documentation across diverse industries / work environments.
- Good hands on knowledge of Object Oriented Programming and Agile methodology
- Extensive experience with Web technologies like ASP.NET, WCF & Web Services, IIS, HTML, ASP, XML, SOAP, XSLT, VBScript, JavaScript, SSRS and SSIS.
- Sound knowledge and experience in developing and deploying SharePoint custom solutions.
- Experience in deploying full SharePoint farms
- Expert knowledge of versioning tools like TFS (Team Foundation Server)
- Expert knowledge of Visual Studio
- Expert knowledge of SQL server, Extensively worked on writing Stored Procedures, Triggers, Functions, Views and Database Design.
TECHNICAL SKILLS
- .Net, ASP, LINQ, Lambda, ASP.Net, SQL, ORACLE, JAVA Script, JQuery, HTML, DHTML, XML, JCL, COBOL, C#, PLSQL, JAVA
- Microsoft SQL Server, ORACLE, MYSQL, IBM DB2 and Access
- 2003, XP, Windows 7 and 2008/2008 R2
PROFESSIONAL EXPERIENCE
Consultant SQL Server DBA
Confidential
Responsibilities:
- Installed and configured a SQL 2012, 2014, and 2016 clustered environments using FCI and stand alone.
- Configured and supported log shipping in both SQL 212 and 2014.
- Used Spotlight monitoring tools to assess various aspects of system performance on numerous SQL Server instances.
- Diagnosed job errors and implemented solutions or worked with developers and/or Server Administration as necessary to solve break/fix and other issues.
- Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements
- Took responsibility of maintaining the SQL Server instances to ensure software is properly installed, security patches were applied and upgrades were done.
- Experience in creating database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions.
- Experience with T - SQL (in writing procedures, triggers and functions)
- Participate in a 24/7 on-call schedule to respond to SQL Server alerts and potential production database issues.
- Configured, and supported Log Shipping and Database Mirroring strategies to support our client's High Availability needs
- Participate in monthly SQL server patch/Service packs installs
- Setup automation with SQL Agent and Database Mail for maintenance, error alerting and job failures.
- Set up and configured SSRS. Created and deployed reports from BIDs
- Use PowerShell to automate some DBA tasks such as restore script creation
Consultant Application Developer
Confidential
Responsibilities:
- Administer, support, and manage our SharePoint environments internally and externally
- Responsible for patching and maintaining healthy SharePoint farms
- Responsible for all solution deployments to our SharePoint farms including third party tools
- Created custom webpart and deployed them to test and production SharePoint sites
- Working in a collaborative development environment, providing assistance & technical guidance to fellow team members
- Prepare technical design documents, perform code reviews, debugging and testing
- Provide inputs in architecting, designing, and implementing a Service Oriented Architecture for the application development group
- Responsible for the reviewing of architecture artifacts that will demonstrate the projects adherence to strategy, design patterns, and best practices
- Created and deployed several SSIS packages to production, schedule them to run on routine basis and monitor error log for errors.
- Support/modify the exiting web services as per user requirements.
- Created different business classes and interfaces using .Net Framework 4.0 with Object Oriented Programming Methodology.
Senior Application Developer
Confidential
Responsibilities:
- Design, implement and deploy several custom SharePoint Solutions
- Designed, implemented and deployed SharePoint 2007 and 2010 for use internally and externally.
- Designed the infrastructure and architecture of the above mentioned SharePoint environments to comply and align with Microsoft’s best approaches.
- Support project teams in defining and reviewing product and software requirements and upgrades.
- Interface with infrastructure group to supply application support requirements and issue resolution.
- Build overall system architecture of information system, encompassing external and internal interface analysis and definition, as well as functional requirement allocations.
- Work with systems users to identify problems with focus on performance tuning and patches.
- Responsible for the deployment/implementation and support of Team Foundation Server (TFS)
- Responsible for revision of codes, output and documentation.
- Responsible for the quality aspects in code development by my team and myself.
- Review test plans for the efficiency and validity.
- Maintain and support .Net company developed applications
- Contribute and update development standards
- Contribute to the alignment of the business needs and IT standards
- Developed a new request system for our construction and maintenance departments. This system uses Oracle for a backend, Oracle BPEL for routing and interfaces with our asset management system
- Provide technical support for our in house applications
- Mentor junior team members
Senior Application Developer
Confidential
Responsibilities:
- Develop Client/Server applications based on client needs and requirements
- Develop and maintain Active Directory interfaces
- Maintain the current DTC (Direct to consumer) software
- Lansa development to integrate web/windows application with JDEdwards
- Maintain the current intranet
- Responsible for the back up and maintenance of all SQL Servers
- Responsible for Adhoc business reporting
Software Engineer
Confidential
Responsibilities:
- CRM Project lead. Lead a team of seven members to successfully upgrade our CRM software and implement in our India, Singapore, Europe and US offices.
- Lead member in the implementation of IFS ERP system.
- Continue to write and support VB6, .Net applications using C#, VB.net and ASP.Net (1.1, 2.0 and 3.0)
- Responsible for several functional areas to include but not limited to Purchasing, Marketing, Accounting and Customer Service
- Continue to play a role in setting standards and procedures for our .Net development environment.
- Written many management reports using MS SQL, Access and Excel
- DTS creation and Automation
- Created Oracle Packages and scheduled jobs to run nightly.
Programmer Analyst
Confidential
Responsibilities:
- Developed and tested an online Workflow system. This system incorporates a web based front, a SQL server for a back bone and an Exchange server for routing and communication system.
- Implemented a department wide standards and procedure for the .Net Platform development.
- Converted our intranet from classic HTML/ASP to a new Intranet using ASP.Net and VB.Net.
- Built/Continue to build new applications using VB.Net and C#.
- Built and continue to maintain and support an Active Directory Driven security escalation application.
- Created a new Active Directory search and update application for our Active directory administrator. I also utilized Active Directory to create a dynamic, living employee/phone directory.
- Developed and tested new electronic forms for various departmental needs.
- Lead member of the SharePoint team.
- A core member of the PeopleSoft team.
- Developed many PeopleSoft Interfaces.
- Develop, maintain and support many management reports for the Payroll and Finance department.