T-SQL Developer (Application)

Job Responsibilities:

  • Database Performance Tuning and Optimization of Database System, Memory Structure, Database Instance, and SQL Queries.
  • Disaster Recovery strategies planning and Implementation.
  • Clustering, Replication, Mirroring and log shipping.
  • Database Cloning and Standby Database.
  • Migration of Database from different Versions of SQL Server as well as with another RDBMS.
  • Documentation of databases, views, stored procedures, triggers and user defined functions.
  • Monitor and manage regular backups and recovery.
  • Installation and configuration of SQL Server Enterprise Database Server Software.
  • Expert in Database Monitoring.
  • Designing and implementing database procedures, Functions and Packages.
  • Proven ability to interface and coordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement database solutions.
  • Identifying performance bottlenecks and tuning SQL queries.
  • Planning, Testing and Implementing Database Maintenance Plans.
  • Implementing Database Backup and Recovery strategies.
  • Implementing tuning and optimization strategies.
  • Supervising Databases on Ms SQL.
  • Patching, Hotfixes and Cumulative Updates.
    • Work with projects for integration of unattended SQL Server 2012.
    • Negotiate with stakeholders and applied the latest patches, Hotfixes and cumulative updates with least downtime.
  • Consulting and supporting of the development team.
  • Implementation of security measures to protect the DB and Database Server from loss or corruption.
  • Proactive Database Capacity Planning and report to the manager and follow-up to do the necessary action.
  • Systematic and Proactive analysis of database.
  • Documentation of databases, Tables, views, stored procedures, triggers and user defined functions etc.
  • Proper Version control to be implemented.
  • Excellent communication, coordination, organizational and follow-through skills.
  • Efficient in the execution of all assignments, eager to take on new challenges.
  • Experience working in Agile development environment.
  • Able to work with flexible schedule.

Job Requirements:

  • Profound knowledge as Database Developer/ Database Architect with experience in working with large and medium databases.
  • Expert knowledge in T-SQL and Microsoft SQL-Server (procedures, Functions and packages).
  • The candidate must have experience in object oriented software development with C#, .NET and the design of software in the database environment (Optional).
  • Ability to understand the functionality of RDBMS Capability to build real-time and highly secure DB, Implementation of logic (using Procedures, functions etc ).
  • Good working experience with Visual Studio, SSDT, TFS and SQL Server Management Studio.
  • Database Cloud hosting.

Skill Set Required:

  • Database Development, Architecture, Optimization, Large Database handling, T-SQL, Microsoft SQL Server 2012/2014, Visual Studio, SSDT, TFS, SQL Server Management Studio, Microsoft Test Framework.

Experience: Around 5-7 yrs experience with minimum 2-3 yrs experience in designing and implementing Microsoft SQL database solutions.

Location : Cochin, Kerala

Send your latest resume to hr@progno.co.in Or, know someone who would be a perfect fit? Let them know!