Qualification:
B.E/B.Tech in any stream /MCA/MSc(IT/CS) or equivalent
Experience & Skills:
· Overall experience of 10 years out of which minimum 8 years shall beof DBA profile.equivalent
Job Objective:
Objective of this job is to administer databases (Microsoft Technologies) for IT projects; conduct preventive and corrective steps for DB upkeep; Evaluate Technical architectures and provide recommendations ; collaborate with DCO /CT teams at data centre, software development teams, Infrastructure outsourcing team, DBAs , network administrator as a consortium (Centre of Excellence) ; Participate & own data centre upkeep and expansion plans, Liaison with user departments for state data centre usage, upkeep of client assets, own & drive Archival/ back up/ Restoration policies. Track SDC (state data centre compliance for conducted tier 2 audits and certifications from norms adherence and renewal stand-point). Benchmark new technologies; work on continuous upgradation of technical artifacts.
Primary responsibilities:
· Candidates with strong database administration experience on SQL Server 2008 /SQL server 2012 and need to updated himself in latest version.
· Strong understanding of - SQL Server 2008 / SQL server 2012
Ø Data structures / DB schema - advise on DB tables /data storage & retrieval optimize performance.
Ø Help application teams identifying work flow optimizations – proactively
Ø Maintain and share web analytics & reporting - application and DB
Ø DB issues troubling shooting &
Ø Optimization of DB issues - run time /periodic DB activities - monitoring indexes/ DB health
Ø Assisting application teams in migration scripts and writing web-services (push/pull data) from/to other databases
Ø Advise application teams on data archival/ purging techniques/Recovery
Ø Devise methodology of central DB repositories like data centres.
· Must have administered DB volumes in excess of 100 GB - for client/server and web-based applications.
· Conversant with Microsoft technologies (.NET 3.5.x or higher), Visual Studio2010/.NET framework 3.5, Tomcat/Apache/IIS AS, SP 2010. SQL/My-SQL DB exp.
· Conversant with HP-UX, TRU 64 Unix, Linux ( Red-Hat/SCO), Windows
· Potential candidate should working knowledge on below :
Ø Data modeling techniques
Ø Tomcat/Apache/ IIS – application servers
Ø Designing techniques and supporting tools
Ø Legacy Application/data Migration - operational and implementation
Ø Application Integration - DB/code driven compatibilities
Ø MVC2 architecture
· Additionally below knowledge islands would be preferred :
Ø Data warehousing & Business Intelligence tools - Informatica/ Abnitio.
·Should be able to collaborate with project resources.