Database Administrator
We are looking for an individual in the role of Database Administrator who will focus improving the efficiency of our infrastructure and availability of our applications.
This person will assist the Primary Data Engineer in the management and oversight of our database infrastructure with a focus on Microsoft SQL server.
This candidate must have strong analysis and troubleshooting skills with experience supporting enterprise class applications and infrastructure.
Duties and Responsibilities :
Assist senior data engineer to ensure smooth operations for database infrastructure; includes setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access
Install and configure SQL server and regular software updates
Provide system optimization as suggested by collected metrics.
Ensure hardware resource configurations are maintained to improve the performance of the systems, including file growth and disk space
Perform periodical audit of database access rights to prevent unauthorized access and compliance with regulatory requirements
Ensure that database backups are always current and available for production databases. Following policies and practices in place to minimize the risk of data loss
Routinely import & update vendor data (Demographics, Polygons, Neighborhoods, and Schools)
Copy production databases into non-prod systems for development cycles
Participate in on-call rotation schedule for systems support
Assist our customers and employees with application issues
Participate in the analysis and staging of SQL code for application deployments, through a release process and other various functions which support the system development life cycle
Required Skills :
Bachelor's Degree in Computer Science, Computer Engineering, or Information Systems + 2 to 3 years' experience
2+ years' experience in Database Administration including :
2+ years' of T-SQL programming
2+ years' working with MS SQL Server 2012 and newer
1+ years' experience with SQL Server analytics (Profiler, DTA, SSMS, PerfMon, DMVs, and system sprocs)
1+ years' experience working Microsoft database cluster technologies (Always-On failover, clustering, or mirroring, log shipping, etc)
1+ years' experience with .NET framework
Strong analysis and troubleshooting skills including experience with SQL Profiler & Management Studio
Proactive self-starter with the ability to take ownership of tasks through to completion
Desired Skills :
Certifications : Microsoft Certified Systems Administrator (MCSA) or Microsoft Certified Solutions Expert (MCSE)
Experience with identifying top resource-intensive queries and suggesting ways to improve performance at the query-level
Experience with SQL replication topologies for data transfer between systems
Experience with SSIS or similar tools for MS SQL data import / export
Experience with Solarwinds, SQL Sentry or similar system monitoring tools
Exciting Benefits we offer :
Market-leading Salary
Medical Coverage Self & Dependents
Parents Medical Coverage
Provident Fund
Employee Performance-based bonuses
Home Internet Subsidy
Conveyance Allowance
Profit Sharing Plan Tenured Employees Only
Life Benefit
Child Care Facility
Company Provided Lunch / Dinner
Professional Development Budget
Recreational area for in-house games
Sporadic On-shore training opportunities
Friendly work environment
Leave Encashment 
