MS SQL Server DBA – Systems Engineer
Company Description

smartShift Technologies is a business transformation company with experience in transforming and managing hundreds of mission critical applications of market-leading organizations of all sizes – early stage start-ups, mid-market enterprises and Fortune 1000 corporations. We are leading the enterprise software management revolution. Through our innovation in automation, we have radically changed the way companies transform and manage their enterprise systems. We have proprietary technology in automated code transformation that has been utilized in SAP to revolutionize updates to Fortune 500 companies. We also deliver large scale cloud transformation projects along with continued managed services in Amazon Web Services, Microsoft Azure, and other leading cloud technologies.

Our working culture combines the meritocratic approach of responsibility and compensation with swarm intelligence: we work as one team concentrating on deliverables under situational leadership. At smartShift our customers are in the center of our activities and we take the risk to get actual results for them. We live in an open and transparent culture which means we are honest with ourselves. Nevertheless, each team member embodies and appreciates accountability and reliability following the principle “I will be the change I seek”.

At smartShift, you will have the opportunity to work in a unique startup atmosphere – learning something new every day while still experiencing top of the line delivery. We like to dress casual, work smart, and constantly challenge the status quo. smartShift Technologies is headquartered in Boston (USA), with offices in Bengaluru (India), and Mannheim (Germany).

We are an ISO 27001:2013 compliant organization and emphasize on information security of our clients.

Job Description

smartShift Technologies is looking for a seasoned MS SQL Server DBA – Systems Engineer to join our team in India.

Responsibilities
  • Perform regular Database administration tasks.
  • Perform HA and DR setup maintenance tasks
  • Analyze the performance metrics and provide tuning recommendations
  • Handle incidents and problems 
  • Perform trend analysis of the incidents/events and help in finding the resolution
  • Analyze and recommend hardening and security features
Skills & Experience

Mandatory

  • 2 to 6 years of experience as SQL Server Database Administrator
  • Installation of SQL Server 2008,2008R2,2012
  • Monitoring CPU and resource Utilization
  • Ensuring all Servers with maximum Uptime
  • User Management like Creation of Logins, Roles and assigning necessary permissions
  • Should have worked on Mirroring, Log-shipping
  • Should have worked on Index Rebuild Activities and DBCC Checks
  • Maintenance plans
  • Job Management like creating jobs and troubleshooting
  • Well versed with Backups and Restores

Desired

  • Knowledge on SQL server 2014
  • Knowledge on Always on setup and Replication
  • Knowledge on Index management
  • Knowledge on Database mail
  • Applying Patches and hotfixes
Qualification
  • Any graduate with 2 to 6 years of experience 
Region
Bengaluru, India