Job Description :
Hi,
Hope you are doing great!!
Please find the requirement below , If you find yourself comfortable with the requirement please reply back with your updated resume and
I will get back to you.

Position: SQL Server DBA
Location: Lexington, MA
Duration: 12+ Months
Mode of Interview :: Phone And F2F
Need Senior Consultant


Must Haves :
At least 5 years of SQL Server DBA experience in an enterprise environment
Large amount of transactions in a day
Impressive communication skills
IT related degree (not philosophy business, or history major – need strong math skills)

Day to day :
This candidate will be working on their Financials platform and systems upgrade and is responsible for 2 Billion transactions a day and $120 Million of revenue for the client per week.
This is not a support or ticket role, it will be high-level, hands on support for implementation, tweaking, and performance tuning. (this is not an architect level role)

We are seeking a motivated Senior SQL DBA to join our existing team of 7 very capable SQL DBA’s supporting some of the most challenging deployments you’ll see using SQL Server.
Our SQL Server environment is responsible for the day-to-day operations of over 2,300 clinics:
- Financials platform: 7 TB OLTP, 12 TB OLAP/DSS database pushing 2.4 Billion database txn’s/day, 700 users, supporting $700M/month in revenue for FMCNA
- Clinical systems platform: 15 TB+ database, 1.5 Billion txn’s/day, 12,000 daily users, facilitating 80,000 treatments/day
- Transactional replication environment with over 150 Million commands per day
- Large scale servers, e.g. 160 processors, 2TB RAM
- Custom alerting and monitoring in support of critical systems
o Central monitor server, monitoring 140+ instances
o T-SQL, powershell, batch files
o Operational dashboard using SSRS
Have you ever wanted to put advanced skills you learned at Dev Connections or PASS into practice and see the outcome in a very diverse environment? Have you always wanted to prove or measure said changes?
If you’re looking to run SQL Server out of the box, this isn’t the job for you. If you have a passion for learning and applying evolving technologies, pushing the limits of SQL Server, striving towards a High Availability Architecture, this could be your dream job!

RESPONSIBILITIES:
Provide written and verbal recommendations to vendor supplied solutions including, but not limited to indexing, code modifications, process improvements and logical and physical data structures.
Provide technical assistance to developers, perform code reviews, identify inefficient code, provide suggestions for rewriting queries to ensure optimal execution
Responsible for administration, maintenance, performance monitoring and availability of enterprise Production SQL server environments
Ensure backup and recoverability of all enterprise SQL server databases.
Work with Data Architect on long term strategy to ensure integrated database systems. Advise on physical data model and implement changes.
Responsible for capturing various database, server, and application metrics, observing trends that will help longer-term capacity planning and analysis efforts
Contribute to the ongoing development of technology and production processes company-wide. Keep abreast of new design tools, hardware, software and technology and make recommendations for future deployment.
Participate in on-call rotation (1 week in 7)
Work closely with the infrastructure team to perform SQL Server installations and to configure hardware and software so that it functions optimally with the DBMS. Plan and implement database upgrades as needed.
Work closely with technical PM’s and other team members to ensure successful project deliveries.
Triage/track outstanding issues, analyze root cause, provide solutions to minimize future occurrences
Ensure appropriate procedures are followed for implementation of data and database changes.
Develop and adhere to common database standards and procedures within a production operations unit. Maintain documentation related to database platforms, guidelines, methods and standards.
Lead projects and efforts driven by database systems, such as upgrades, database appliance and consolidation.
Provide technical leadership. Mentor junior DBA’s on the team on database technical details.

EXPERIENCE AND REQUIRED SKILLS:
8+ years of related experience in SQL Server, including replication, HA and DR techniques
Strong aptitude for tuning T-SQL
Experience in performance tuning, query optimization using Performance Monitor, SQL Profiler and other related monitoring/troubleshooting tools
Process oriented engineer with strong execution and follow through skills. Self-starter.
Experience supporting SQL Server editions 2005-2014 in a production environment
Strong working knowledge of Windows OS, physical hardware, storage systems, networking
Experience with AlwaysOn, clustering, replication, virtualization and high transactional enterprise systems.
Working experience with SSAS, SSRS desired
Strong written and oral communication skills.
Team player with ability to multitask with minimal supervision. Excellent analytical and problem solving skills.
Proven self-starter with initiative and ability to not only see the bigger picture but also effectively communicate to IT Management and SME’s in the business
SQL certification desired