In Time Tec is an award-winning IT & software company. In Time Tec offers progressive software development services, enabling its clients to keep their brightest and most valuable talent focused on innovation. In Time Tec has a leadership team averaging 15 years in software/firmware R&D, and 20 years building onshore/offshore R&D teams. We are looking for rare talent to join us. People having a positive mindset and great organizational skills will be drawn to the position. Your capacity to take initiative and solve problems as they emerge, flexibility, and honesty, will be key factors for your success at In Time Tec.
Job Overview:
The position requires an experienced and ambitious candidate who is passionate about technology and self-driven. We have an energetic workplace where we welcome innovative ideas and offer growth opportunities and a positive environment for accomplishing goals. Our purpose is to create abundance for everyone we touch.
Job requirement:
4-6 years of experience as a database specialist in Microsoft SQL Server.
Experience and expertise with Microsoft SQL database administration, T-SQL development, and PowerShell Scripting.
Exposure to Database monitoring and health check tools.
Experience in database maintenance, like fragmentation checks including daily backups and recovery, re-index operations, update statistics, and other system commands such as DBCC and DMVs
Exposure to configuring and managing SQL Server High-availability data solutions Log shipping, Mirroring, and data synchronisation solution Replication.
Must have good exposure in setting up and troubleshooting the Always-On High availability solutions.
Must have experience in PowerShell scripting and good to have knowledge in dbatools.
Good knowledge of designing database files and layouts for TempDB
Strong SQL knowledge and experience in creating database objects such as tables, views, stored procedures, Triggers etc.
Generate code to extract, transform and load data from one data source to another (SSIS).
Performance tuning of key queries.
Good exposure to OLA Hallengren and Brent Ozar performance monitoring scripts.
Identify and write the best possible code in case of new deployments or when rewriting code when migrating to a newer version of SQL Server.
Experience in database security and auditing.
Experience monitoring multiple databases; database performance management and tuning.
Experience performing database migrations; experience analyzing current database performance and making projections for future growth.
Good to have knowledge on Reporting tools like PowerBI
Excellent written and verbal communication skills and the ability to handle multiple tasks under tight deadlines.
Good team player and able to work with teams across the regions.
Must Have
MS SQL Server Database Administration.
T-SQL Development: Writing, understanding and modifying the existing SQL queries(CRUD, Joins, Sub queries etc.), stored procedures, functions and triggers.
PowerShell Scripting: Writing, understanding and modifying the existing PowerShell scripts and new scripts as per the requirement.
Good to have Knowledge in
PowerBI
SSIS
DBATools
Qualification Required:
Candidates with B.Tech or M Tech degree are preferred.
How You'll Grow at In Time Tec
In Time Tec, has made significant investments to create a stimulating environment for its people to grow. We want each of our employees to grow in their way and play their roles while honing their ownership abilities. As part of those efforts, we provide our professionals with a range of educational opportunities to help them grow in their career.
Our guiding principles of leadership, trust, transparency, and integrity serve as the foundation for everything we do and every success we achieve. We are proud of these fundamental principles since they demonstrate our dedication towards them as a One Team.
We value every individual by giving them the freedom to make daily decisions that can support their health, well-being, confidence, and awareness. Our leadership team is there to offer the safe base by giving the right budding environment, instruction, tools, and chances necessary for your professional development in achieving your goals.
Our people and culture work together in a collaborative environment, making In Time Tec a thriving place to work. You can find out more about Life at In Time Tec here.