We provide IT Staff Augmentation Services!

Sql Server Dba / Developer Resume

4.00/5 (Submit Your Rating)

Objective:

To work in an IT Management position where I can effectively use my technical, management, and leadership skills and experiences through software, hardware & networking project implementation, IT strategy and policy formulation, supervision, resource allocation, and hence contribute to the short and long - term organizational effectiveness.

Summary of the Relevant Skills:

  • Progressive domain expertise in the areas of management, supervision, development of IT / IS projects in government, industry, and academia. Strong ability to plan, forecast, set-up goals, implement solutions, coordinate various operational groups’ day-to-day activities. Proven project management and people skills to ensure high availability of mission-critical applications and infrastructure. Excellent problem solving, organizational & customer service skills. Ability to work independently and in team environment to implement, or recommend efficient and cost effective IT solutions.
  • Client/Server and Web-based application design and implementation using Microsoft Technologies (C#, VB.Net, ASP.NET with backend VB.Net and C#.Net) using backend MySQL, MS SQL and Oracle databases. Report development using MS SQL Reporting Service (SRS), Crystal Report, automated data transfer and conversion process using SSIS package. Client side JavaScript, Ajax, YUI and JQuery.
  • Java (client/server) and J2EE technologies: Struts (MVC), Spring, JSP, Servlet, Tag Library/JSTL & Custom Tag, EL, JFC, Swing/AWT, XML, SSL, RMI, thread, socket, JDBC & JDBC/ODBC bridge, Tomcat, Eclipse, JUnit Testing Framework, iText pdf API.
  • Web site design and development using Macromedia Dreamweaver, Fireworks and Flash, Adobe Photoshop, CSS, JavaScript, DHTML/DOM.
  • Knowledge Management (KM) processes, information classification (taxonomy), document indexing using vector space model, implemented Search Engine during 1995 using PERL CGI in Unix.
  • Demonstrated skills in design and development of web-based, e-commerce and client/server applications that include concept development, planning, requirements analysis, design, development, integration, testing, implementation, operations, and maintenance. Systems design using OOA & OOD, SDLC, Waterfall and Agile (XP) methodologies. Skills in software system modeling, Use Case Analysis, UML diagramming; resource & risk management; technical documentation; disaster recovery/continuity planning, system audit and security assurance. Proven experiences to lead, guide and mentor developers and administrators for the complete life-cycle development and deployment of applications.
  • Experiences in large database design using PL/SQL and T-SQL for academia and industry, in-depth knowledge of database modeling tools and technology alternatives. Practical knowledge on query optimization and Database security adherence. Experiences in time-series data analysis using SPSS and MS Excel.
  • Ability for delegation of tasks and mentoring team members. Capable to mentor developers for system development using application languages such as Java, C, C++, C#.NET etc. including debugging and testing. Able to write user-friendly documentations on system design and user guide. Assessment of training needs, preparation of multimedia training content, and conduction of training. Preparation of conference presentation and participated in conferences, dissemination of best practices across the organization’s stakeholders.
  • Possess Project Management skills using Agile and Waterfall methodologies while complying with the standards, people / resource management, and schedule/budget. Worked with diverse users group to gather the requirements through effectively communication with senior management, cross-functional user groups, and tech-savvy and non tech-savvy end users.
  • Participated in complete life-cycle application development. Complied with organizations’ standards and business strategies while designing and deploying client/server and web-based solutions. Provided on-call and after hours (24x7) support for critical production systems. Also participated in hardware upgrade, applications of patch/service pack, and worked to serve systems and databases security assurance.
  • Fast paced and self-taught IT professional. Possess general knowledge in accessibility in designing web applications and web site.

Chronological Experiences:

SQL Server DBA / Developer, Confidential,San Luis Obispo, CA

Aug’09 to Jan’11

  • Participated in day-to-day database development and administration tasks such as: creation and maintenance of DB objects (tables, constraints, indices, views, triggers, and stored procs), backup/recovery, establishment of Linked server with state side, scheduling of jobs in SQL Agent, Performance Monitoring, and Security Auditing etc.
  • Successfully rolled out SQL server upgrade project. A server with 64-bit SQL Server 2005 is deployed in ITS collocation facility for Micros Application. Provided recommendations for server configuration, capacity planning and network setup. Defined backup maintenance plan for full and transaction log backup together with compressing the files.
  • Participated in all phases of the systems development life cycle, including planning, analysis, design, programming, test, implementation and ongoing maintenance and support. Worked on implementation of PAF tool for the Grant Development Office (GDO) of CalPoly to integrate with Grant Management (GM) of CalPoly Corporation (CPC) using JSP, JSTL, YUI Auto complete/JavaScript, used Windows AD authentication of Tomcat. Worked for development and maintenance of Crystal reports.

Software Engineer - III, IT Department. Confidential,San Luis Obispo, CA

Sep’07 to Jul\'09

  • Users’ requirements gathering, design and implementation of client/server and web-based applications(C#, VB.Net) using Visual Studio 2005 & 2008, MS SQL 2005 & 2008, SQL Reporting Service (SRS), automated data transfer and conversion process (ETL) using SSIS package.
  • Worked for Transient Occupancy Tax (TOT), implemented new Interface for Audit. Participate in maintenance and new version roll out in Development, Staging and Production Environments. Staging roll out of a client/server application using C#, SRS and MS SQL 2005.
  • Worked for conversion of an Access Application for Child Support Service. This client/server application has business object, data access layer and it uses SRS report.
  • Worked for development of web-based Application (Asset Inventory System with Business Continuity Planning) using C# and MS SQL 2005. In this Agile process I participated in requirements gathering, technical design using OO design, coding, and testing activities during each sprint. Participated in web based application design using ASP.Net with backend MS SQL 2008 database. Designed and Implemented SSIS package for data conversion and transfer of Property Data. Transactional feature is implemented to roll back database when SSIS scheduled operation fails. Selected data items are displayed for the public when they search by Street Name or APN.
  • Participated in Database design (table, views, indices, stored procedure). Query optimization using SQL profiler, Knowledge on Server performance tuning and security adherence.
  • Worked in IBM mainframe for COBOL (VSE) application development program development using COBOL to update ZIP database in mainframe. Now working on Mainframe to design a CICS on line application that will generate report for Tobacco Licenses. It will access the IBM DB2 database in Mainframe. Maintenance of MicroFocus COBOL applications for Annual Budget.
  • Served in the committee for the IT Department’s Core Value Development, and Strategic Plan preparation.

Knowledge Management Specialist/Director, Confidential,Jackson, MS

Jan’04 to July’07

  • Implemented web-based Textbook Adoption System (TAS). Each of the departments compiles the text book and reference book list for the offered courses in a semester. Office of the Academic Affairs produces the report and advises the campus Bookstore/other publishers to make available the required number of books for the enrolled students. The MVC 2 architecture is followed to implement the web app using JSP, Struts, Java beans in Tomcat and MySQL backend. Pdf output is being implemented using Java-PDF API iText.
  • Worked as the Project Manager and Architect for the development of Career Portal for the JSU’s Career Service Center. The system will provide the opportunity to job seekers (students) to put their skill set and the interest for the type of job they are looking. Companies could circulate openings together with the sought skills and experiences. The system makes a match of skills between published jobs and the students, and notifies to the company with the profile of the registered students. 3-tier Architecture using Java Beans with backend Oracle Database is being used for the system. Participated development, testing and deployment in a team environment using XP methodology.
  • Developed web-form to create database and serve better to the prospective students. Student could request information package from different departments at JSU over the Internet. The system was designed using MVC framework with JSP, Servlet, Java Mail API to route the request to designated recipient. Application was hosted in Tomcat Java Server with MySQL backend.
  • Supervised a team of application and web developers who were working for development, testing & maintenance of web based applications, Academic Affair’s website and Knowledge Management (KM) portal.
  • Worked closely with the Associate VPs for the Academic affairs to design the templates for the Strategic Planning and Annual Report. Conducted training sessions for online/offline submission of the documents by the various academic units at the JSU. Coordinated the compilation processes of these templates by various academic and non-academic units, and provided data support for analysis of the completed reports. Worked to develop template for faculty electronic Portfolio, supervised compilation process, and established searchable repository. Developed template to collect data on university & industry collaboration. Worked as Project lead to implement web-based system on university and industry collaboration. . Worked to compile institutional time serious data for the Office of the Academic Affairs. Provided data support for the Strategic Plan preparation by the Academic and Non-academic units.
  • Established database and provided data support to compile following reports: fall-to-fall cohort retention rate, and 4th, 5th, 6th year graduation rate; enrollment analysis by major and department, undergraduate & graduate program; low and high producing academic units’ trend analysis and reporting; semester and academic year wise faculty work load report; ratio of faculty to student enrollment (FTE) report; degrees granted by various programs over years; community service and service learning hours by students; faculty demography (tenured, non-tenured, adjunct, relevant terminal degree) in compliance with the accreditation board; student on probation by major; performance based faculty pay/raise calculation.
  • Participated in procurement processes to procure and implement technology solutions for Academic IT, spent about half a million to buy Servers, Printers, Desktop PC and Mac, and Video Conferencing systems, and saved substantial amount on year 05.
  • Participated in SCT Banner Student and HR modules training and updated information for Faculty in Banner System.
  • Implemented KM Systems and Solutions (KMSS) at the JSU and advocated the Knowledge Management in different forums through participation in conferences & seminars.
  • Presented CLI’s Virtuoso e-Learning Platform in “Creating Future through Technology” Conference. Created Training contents and conducted training on workflows for KM tool for users.
  • Designed and completed the Assessment, Planning and Knowledge Management website with templates and contents. Navigation:
  • Pursued Project Management tasks for implementation of the, an accreditation system for the College of Education.

Senior Software Engineer / Consultant for Confidential,Entopia Inc., Belmont, CA

Feb’03 to Dec’03

  • Supervised the day-to-day works related to servers’ operation, website maintenance, implementation of the various projects related to Knowledge Management (KM) by the Office of the University Provost and Vice President for the Academic Affairs at JSU.
  • Worked for the development of animated training contents including the “Scholar Engager-Faculty Research Management Process”. Supervised the deployment of server and software for the Digital Portfolio development for JSU faculty and students.
  • Supervised fulltime staffs & Research Assistants to complete various tasks that include web-based application development; Quantum, IIS, Apache, Linux / Windows server administration; training material development; hardware and software configuration and installation; and technical supports to users.
  • Made several presentations in the University President’s Office, Dean’s Council meetings and conferences in regards to the activities related to the KM at JSU. Worked and supervised the design and development of online KM survey in ASP, MS SQL and JavaScript for the College of Education.

Senior Application Developer & DBA, Confidential,Atlanta

Oct’99 to Sep’02

  • Worked as a lead member of the project team for the development and deployment of Internet (3-tier) based Practice Management Application .Server & client side design, development and testing using VisualAge for Java. Experiences in J2EE Server & client side programming using RMI, Thread, Socket, SSL, JDBC and JDBC/ODBC, JFC, Java Beans/EJB, Servlet, and JSP. Experiences in GUI and SSL programming, produced build using ant.
  • System Architect for the complete life-cycle development and deployment of e-Handheld (Pocket EMR) application. This application integrates programs developed in e-VB, Java and VB6.0 with back-end MS SQL6.5/7.0/2000 & Access. Installation of Wireless LAN connectivity for the Pocket PC & ensured HIPAA standards and securities for the data interchange and transaction processing.
  • Visual Basic with SQL7.0 & Oracle 9i: Transformed database from SQL2000 to Oracle 9i & converted several modules of a client/server application in VB6 run in Oracle 9i using OO4O. Oracle server administration. Worked for the development & maintenance of web-based applications using ASP and ActiveX controls with backend database (MS SQL7.0/2000).
  • Developed tool in VB6.0, using SQL7.0, RDO and RDC (DLL) to automate crystal report file processing. Designed and test Crystal Reports for the client/server and Internet based software products. Working knowledge on 3-tier application development and deployment using MTS and ActiveX components using VB5.0 & VB6.0.
  • Developed tool for database maintenance using RMI API, JDBC, and SQL Stored Procedures. Performed system integration project for the data synchronization between databases of two applications. Data conversion and upload using XML and Java.
  • Data modeling and Database design (user defined data types, normalized tables, constraints, views, triggers, cursors and stored procedures). Database, Web and Application Servers’ performance tuning and monitoring. DTS, Link server configuration and distributed queries. Conducted application stress test for MS SQL, DB2, and Oracle. JDBC driver selection. Established Replication site over the Internet using MS SQL and Double Take. Ensured security for DB and Web servers.
  • Installation of RAID subsystem with NT Enterprise Edition, PDC, BDC, WINS, MSCS, Active/Active MS SQL Cluster Servers, WLBS for IIS servers, SMTP in NT. Defined performance measures and alerts for NT and SQL servers. Monitoring and administering NT computers\' services remotely through MS VPN (PPTP). SCSI backup device and Backup Exec installation and defined / scheduled jobs for Full / Differential / TransLog backups. Knowledge on VPN (MS PPTP & Intel’s Shiva), multi subnet NT domain and Windows 2000 and SQL 2000 deployment.
  • Installed and configured Red Hat Linux, Sendmail, POP-3/IMAP4, SAMBA and PCX. Wrote pam mssql.so in C for POP-3 to authenticate from MS SQL database. Knowledge on LDAP implementation in Linux. Knowledge on COM development using ATL in VC++6.0.
  • Worked as a Mentor and provided technical supports related to Software development, Database Development & Administration, NT & Network Administration issues for the 24x7 Data Center and the company’s networks.

Manager, Systems and Network, Environment and GIS Support Project for Water Sector Planning

Dec’97 - Aug’98

    • Designed LAN architecture, installed SCSI & hardware, NT4 servers (BDC & PDC) with RAID L1. Configured server (PDC) as a file and application (Office97) server. Configured RAS, DHCP, WINS, and DNS. Installed TCP/IP network printers (HP 5Si), Plotters & Digitizers (Calcomp). Implemented network security and virus prevention. Established Internet connection and email communication. Installed HP SureStore 24GB DAT and Cheyenne ArcServer for automated backup. Pursued UNIX integration with NT network using Samba. Shell and PERL scripting.
    • Installation/upgrade of ArcInfo, ArcView, Internet Map Server. Application development using MS SQL server 6.5 and VB5.0.

We'd love your feedback!