Description
Job Responsibilities
Microsoft SQL Server administration and maintenance functions of production and QA databases in a 24/7 mission critical environment
Design and develop architecture for Datawarehouse including source data ETL strategy, data movement and aggregation as well as data quality strategy
Participate in database server architecture and design as well as server environment recommendations for the overall infrastructure solution including storage capacity planning
Responsible for database alerts, maintenance plans and scripts
Manage database security and control access permissions and privileges
Maintain the health, performance and integrity of the database systems
Responsible for availability, reliability and integrity of business data stored in production databases
Communicate regularly with the development team, business and operations team to ensure the security and confidentiality of data
Resolve production database issues with team members and implement improvements to prevent a reoccurrence of the issue
Backup and restore databases as necessary
Qualifications
5+ years of experience working as a hands-on MS SQL Server Database Administrator
Strong skills and experience in performance tuning - Index, Table, Queries and Stored procedures
Experience in replication, Datawarehouse and scalability
Expert data modelling skills for enterprise data warehouses and data marts
Strong knowledge designing SSIS packages
Strong knowledge of SSRS
Experience with one or more Business Intelligence tools
Experience with Triggers, Stored Procedures and SQL Server Queries
Experience in a 24/7 high availability production database environment
Ability to think logically and analyze business process requirements and convert them to accurate database structure and logic
Agile software methodology experience a plus