Sr Developer/DBA

Nishanth S.R

Kailas Nagar, House No: **, Kazhakuttom P.O, Thiruvananthapuram, Kerala. Contact No: +91-984**-*****

Pin: 695582.

Phone: +91-047*-*******

E-Mail:***********@**********.***

Job Objective: To participate and make significant contributions to challenging software projects in progressive and reputed companies

Summary

Expertise in sql programming and administration for mssql server, with a total of 6 plus years’ experience.

Involved in various phases of Software Development Life Cycle including Analysis, Design, Testing, Implementation and Maintenance.

Extensive experience in developing Stored Procedures, Views, Triggers and Complex Queries on SQL Server 2000/2005/2008/2008 R2.

Have worked with technologies and tools like Microsoft SQL Server 2000/2005/2008/2008 R2, Oracle 10g and Mysql.

Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP

Proven track record as a successful team member in the design and development of client server products for international clients.

Accustomed to working in a very fast-paced environment, ability to handle multiple tasks simultaneously

Good organizational and communication skills

Roles and Responsibilities

Installation, configuration and upgrading of Microsoft SQL Server/MySQL server software and related products.

Establish and maintain sound backup and recovery policies and procedures.

Take care of the Database design and implementation.

Implement and maintain database security (create and maintain users and roles, assign privileges).

Database tuning and performance monitoring.

Setup and maintain documentation and standards.

• Do general technical trouble shooting and give consultation to development teams.

• Interface with MSSQL/MySQL/Oracle for technical support.

Area of expertise in DBA Description Rating (out of 10)

Administrative Work on maintaining the server and keeping it running. Concerned with backups, security, patches, replication, etc. 6

Development Works on building queries, stored procedures, etc. that meet business needs 7

Architect Design schemas. Build tables, FKs, PKs, etc. Work to build a structure that meets the business needs in general 7

Data Warehouse Responsible for merging data from multiple sources into a data warehouse 1

OLAP Builds multi-dimensional cubes for decision support or OLAP systems. 3

Software Skills

Databases : SQLServer 2000, 2005,2008,2008-R2

,MySQL

,Oracle10g

Microsoft Technologies : ASP.Net, ADO.Net, Web Services

Programming languages : c#, VB.Net

Tools : Visual Studio 2003, 2005 & 2008

: MyEclipse 7.0,

:Sybase power designer

Professional Profile

June 2010 – July 2011 : Database administrator,

Arivameddata infotech pvt ltd,

L-1,Thejaswini

Technopark campus

Thiruvananthapuram

Nov 2005 – June 2010 : Database administrator

Proxy Systems Pvtd

(Subsidiary of Mercator Geosystems, Netherlands)

Technopark Campus

Nila Building

Thiruvananthapuram

Feb 2005 – Nov 2005 :Software Programmer.

National Informatics Centre,

ER&DCI Buildings, Vellayambalam,

Thiruvananthapuram.

Project Profiles

# medchek –practice management

Client : Company Owned product.

Tenure : Oct 2010 – march 2011.

Team Size : 7

Role : Project Manager, DB Design.

Software used : visual studio 2008, sql server 2008

Environment : windows

Medchek -practice management is mainly used for the Clinic Management System. On this Application has been enacted as appointment scheduling, patient data management, front desk collection management.

Responsibilities:

• Database administrator

• Project management

# ZFactuur

Client : Company Owned product.

Tenure : July 2007 – June 2010.

Team Size : 9

Role : DB Design, sql programming.

Software used : MySql, Java1.5.

Environment : Linux

ZFactuur is a web based application developed on SOA, which fully automates the flow of invoice from vendor to the customer. The stakeholders include various leading vendors in the Netherlands and their customers. The application enables the vendor to send their invoices as XML in EAV standard, which will be converted into our own internal format and is persisted in the ZFactuur backend. The vendors as well as the customers are allowed to login to the application to view their respective invoices based on the various subscription types. Being able to import the invoices into various accounting packages is one of the core elements of the ZFactuur service. In addition to this the service allows the users to download the invoice information in Tele-banking format, and can make their payment through bank portal.

Responsibilities:

• Database administration

# CIS (Compliance Information System)

Client : Rabo Bank International, Netherlands.

Tenure : Apr 2006 – Jan 2007.

Team Size : 9

Role : DB Design, sql programming, Coding.

Software used : Sql Server 2000, ASP.Net 2(C#).

Environment : Windows NT

Web based application for calculating and mitigating risk involved in implementing a business strategy for a particular location. Business strategies are new loan plans, new deposit plans etc

The roles involved are GCO, CO, LCR and Administrator

The possible risks and the business strategies are introduced by the Administrator into the application. CO relates a business strategy to the applicable risks in his region.LCR can modify this association and finally expose the location for compliance planning. LCR scores the risks for each business strategy and GCO can decide whether the business strategy is to be implemented in that location in that region

Responsibilities:

• Database administration and deign

• Coding

# AseTrak

Client : Rabo Bank International, Netherlands.

Tenure : Nov 2005 – Apr 2006.

Team Size : 9

Role : Coding.

Software used : Sql Server 2000, ASP.Net (C#).

Environment : Windows NT

A web based scenario tool for monitoring and analyzing entities against an established set of security requirements. Entities are software to be used inside the bank, places where bank is going to start a new branch etc

A set of baselines (questions) determine the score for an entity in the assessment process and if the residual risk is high, an action plan is agreed with the objective of further reducing or mitigating the risk

Responsibilities:

• Database design ,administration

• Development

# PEARL (Package for Effective Administration of Registration laws)

Client : Govt. of Kerala.

Tenure : March 2005 – November

Team Size : 1

Role : Web Design, Coding, Testing.

Software used : Sql Server 2000, ASP.Net.

Environment : Windows NT

Converting already existing project (vb) into a web based application as a part of computerization of sub register office

Responsibilities:

• Web Design, Development, Testing

# ISDP (Integrated Service Delivery Project)

Client : Govt. of Kerala.

Tenure : January 2004

Team Size : 2

Role : Web Design, Coding, Testing.

Software used : web services, Sql Server 2000, VB.Net

Environment : Windows NT

Synchronization of database of land records system between SRO, Taluk and Village offices using web services technology of .Net. Web Services is configured at Taluk office and two windows client applications at village and SRO will access web services to upload and download the data

Responsibilities:

• DB Design, Development, Testing, Implementation.

Educational Qualification

Name of Examination Board /

University Name of Institution Year 0f Passing

M C A M.G University M.A College Of Engineering 2004

BSc Physics Kerala University SN college,Chempazhanthy 2001

A.I.S.S.C.E C.B.S.E No: 1 C.R.P.F Pallipuram 1998

A.I.S.S.E C.B.S.E No: 1 C.R.P.F Pallipuram 1996

Personal Profile

Date of Birth : October 25, 1979.

Marital Status : married

Nationality : Indian

Permanent Address : Kailas Nagar, House No: 34,

Kazhakuttom P.O,

Thiruvananthapuram,

Kerala.

Pin: 695582.

Phone: +91-047*-*******

Contact this candidate