MS SQL DBA(Database Administrator)

logo

MS SQL DBA(Database Administrator)

Cloud Analytics Technologies LLC

icon Bethlehem, PA, US, 18018

icon20 June 2024

Apply Now

Job Description:

  • Will be in-charge for Design, development, optimize, performance tuning of custom applications.

  • Responsibility includes Troubleshooting and problem solving of MS-SQL server and databases.

  • Will be responsible for writing, reviewing and recommend optimization techniques for SQL queries and stored procedures.

  • You will be responsible for Installation, configuration and upgrading MS-SQL server, SSRS, SSIS and IIS, Web services and related products.

  • Will be in-charge of Troubleshooting and problem solving of MS-SQL server and databases.

  • Will be in-charge of Periodic monitoring of the databases.

  • Doing performance improvements on the databases.

  • Improvements and maintenance of databases to include rollout and updates.

  • Data driven Web Services for IIS, WCF and MS-SQL.

  • Work closely with management, engineering and support to provide direction in identifying and resolving database related problems.

  • Requirements collection from internal, external clients and documentation.

  • Unit testing and debugging of applications in various stages of development life cycle.

  • Work collaboratively with peers in all the stages of development life cycle.

  • Write complex MS-SQL scripts for database merge or fixes.

  • Write efficient procedures for search routines and complex business logic.

  • Develop Business Intelligence package using SQL SSIS by collecting requirements from the customer.