Job Description
Exp -3-4 year
· Write and optimize in-application SQL statements, Procedures, Views Etc.
· Ensure performance, security, and availability of databases
· Prepare documentations and specifications
· Handle common database procedures such as upgrade, backup, recovery, migration, etc.
· Profile server resource usage, and optimize and tweak as necessary
· Collaborate with other team members and stakeholders
· Prepare & optimize SSIS package & Schedule them
· Prepare SSRS reports
· Work on SSAS
Critical Success factors:
· Strong proficiency with SQL and its variation among popular databases
· Experience with some of the modern relational databases
· Skilled at optimizing large complicated SQL statements
· Knowledge of best practices when dealing with relational databases
· Capable of configuring popular database engines and orchestrating clusters as necessary
· Ability to plan resource requirements from high level specifications
· Capable of troubleshooting common database issues
· Familiar with tools that can aid with profiling server resource usage and optimizing it