Job Summary :
Database Architect with 8 12 years of experience
The following are key knowledge areas required for a :
8 to 10 years of SQL Server Database Administration experience. (2000, 2005, 2008, R2)
SQL Server patch management
Expert level of SQL Server RDBMS installation / configuration, patching, troubleshooting, performance tracking / tuning, back-up / recovery, remote monitoring skills with hands-on experience in large and very dynamic environments.
Experience with SQL Server Cluster, Replication, Log Shipping for HA / DR.
Experience with deploying SQL Server in virtualized environment. (VMWare, Hyper-V)
Excellent written and verbal communication skills.
Experience with very complex database environments.
Experience in SQL and / or PL / SQL or MYSQL.
Experience in working SOX controlled environment, change control, and validated systems.
Strong willingness to learn new technologies.
Should be a team player.
Experience / exposure in Microsoft Reporting Services Technologies.
Experience with building ODS, Data warehouse, and data marts.
Experience in Implementing Enterprise architecture principles for databases.
Very large Database support and administration.
Any retail business systems experience is nice to have.
Experience in Open source, Big Data & Clustering
Experience in Cloud computing or experience with hosting databases in the Cloud, including archival of large amounts of data
Willingness to learn and Positive 'can do' attitude is a must.
Bachelor’s degree in Business Administration, Computer Science, Information Technology or equivalent work experience.
Senior Microsoft SQL Server database administrator with a minimum of 10+ years' experience as a DBA in an operational environment.
Experience working in a global, leveraged outsourcing environment, supporting multiple customers within an ITIL service management framework, is highly preferred.
Expert knowledge of Microsoft SQL Server 2012 and 2008 physical DBA activities
ITIL Foundation certification a plus!
Experience with ETL and data warehouses
Strong knowledge of relational algebra or relational calculus
Expert with entity-relationship diagrams
Skills & Ability :
The following are key Skill and Ability areas required for a :
Must possess excellent communication skills.
Should be able to multi-task and manage time effectively.
The following are general responsibilities of :
Serve as the technical expert in SQL Server technologies.
Liaise with functional and development teams.
Participate in SQL Server database systems design and operations.
Participate in software upgrades, revisions, patches, and fixes mandated by the vendor.
Assist in the resolution of complex problems in support of production; including on call support.
Ensure that the detailed physical design of database and data structures comply with data policies, standards, principles, and meets the established level of service agreements / goals for the system.
Create, develop, and review the physical data model created from Logical data model.
Maintain solid technical skills in R / DBMSs, products, utilities, protocols, and techniques.
Manage and monitor SLAs for uptime and performance of SQL Server databases.
Demonstrated experience in working on root cause analysis for SQL Server database issues.
Flexible, adaptable, and able to manage multiple tasks in a dynamic environment.
Proactively monitor the database systems to ensure secure services with minimum downtime.
Mentor and provide technical support to all team members.
Project management for Database technical projects.
Provide on call support on a rotating basis.
Install, configure, upgrade, and manage SQL Server
Configure and manage database maintenance, including backups, dbcc's, update statistics, and any additional required maintenance
Apply SQL Server-related patches
Manage SQL Server clustering, Replication, and Always-On environments
Provide SME-level representation for DBA team to account leadership, application owners, and infrastructure teams
Participate in an on-call rotation as part of a leveraged team
Represent database administration team in DR and project activities