Prestigious Enterprise Company is currently seeking a SQL Server Developer with DBA skills. Candidate is responsible for providing support, performance tuning and design consultation for enterprise database applications. Candidate will partner with the development teams throughout the application life cycle to ensure the database is optimized ensuring maximum application performance and availability. The individual will partner with the system DBA's ensuring that the database environment is stable, reliable, robust and kept current in regards to the database and patching levels.
Implement and maintain the database design including physical and logical data models.
Advanced SQL, T-SQL programming skills with ability to write, debug and tune procedures, functions and ETL packages.
Tune database queries for optimal performance.
Work collaboratively with application development teams and business to better understand overall application needs and make recommendations accordingly.
Partner with project teams and interact with customers to find solutions for projects and operational issues for existing and proposed databases environments.
Identify, analyze and solve problems related to database, applications or reporting in a thorough, timely manner.
Develop and document standards, policies, procedures and key performance metrics that support the continued improvement of IT services.
Assist developers with all the database activities.
Monitor application related jobs and data replication activities.
Perform code reviews and SQL code deployments.
Assist QA Teams in Unit and Stress testing operations.
Anticipate and devise possible solutions to application and database-related problems.
Recommend and maintain SQL Server configurations for both production and development environments.
Assist system DBA team by deploying SQL Server upgrades and service packs.
Assist system DBA team by performing backup, recovery and archival tasks on databases management systems.
Participate in On-Call rotation for critical production support.
Perform all routine scheduled SQL Server and database maintenance.
Minimum of 5 years of experience working as a database developer/architect in a SQL Server environment.
Minimum of 3 years of experience working as a database administrator.
Minimum of 3 years of experience working with large, complex databases in a large enterprise environment
Possess a solid understanding of the relationships of architecture components within technology infrastructure.
Expertise with the following technologies: SQL 2008/2012, SSIS, SSAS, SSRS.
Experience working with .Net, C# technologies.
Knowledge and experience working with source code version control systems.
Excellent Data Modeling experience.
Strong understanding of coding methods and best practices.
MCDBA or MCSA database development certification a plus.
Familiarity with other database technologies a plus.
Excellent communication skills a must.
Ability to provide 24x7 support and participate in an on-call rotation