The Database developer develops and maintains Microsoft SQL databases for all environments (Dev, Test, QA/Cert, Prod), as well as responsible for SQL server reporting duties. On occasion, will perform database backups, support of databases across internal and end-user applications. The Database developer works with SQL Server and third-party tools as well as Microsoft Visual Studio to assist in the management. Profiling, optimization and debugging of the databases in transaction processing and data warehousing environment. The Database developer position works in a team-oriented environment supporting 24X7 application operations.
Essential Duties and Responsibilities:
Database maintenance and optimization in an development environment
SQL set up, administration and security
Testing and debugging assigned components and units
ETL design, development and maintenance
Regularly performing query and DB performance optimization
SQL server reporting responsibilities, SSRS, SSAS
Development in Visual Studio (C#)
Bachelor’s degree in computer sciences from an accredited college. Equivalent work experience may be substituted for degree.
Knowledge, Skills and Abilities Required:
Must have skills:
6 + yrs minimum performing development database work in a software development environment
SQL set up and administration experience
Profiling expertise with large, complex databases: running SQL queries, retrieving data…..
Optimization expertise with large, complex databases: load testing, trace and ID experience.
Debugging and database concurrency experience
Knowledge of Data warehousing/building cubes
Experience with SQL Analysis Services, Integration Services, or Reporting Services
2 yrs experience writing software programs in .Net or JAVA environment, preferably with C#, ASP.net or Visual Studio
Ability to solve problems quickly and completely
Ability to multi-task and stay organized in a dynamic work environment
Excellent communication skills, with an emphasis on verbal and written communication
Demonstrated ability to work collaboratively within the team
Experience working in an environment with integration solutions using web services built with WCF, WSDL, SOAP or REST
Some working knowledge and experience of Entity Framework, LINQ or nHibernate
Experience with Azure Data Factory, Azure Event Hubs, Azure SQL / Azure Synapse Analytics Azure Cosmos DB or other NoSQL dbs, Azure Power BI
Disclaimer Statement: The preceding job description has been written to reflect management’s assignment of essential functions. It does not prescribe or restrict the tasks that may be assigned.
Valid through: 9/4/2020