Job Description :
Responsible for all information technology database engineering operations activities and resource management for 182 Proficy Servers (Production and TRN) with a 24X7 Coverage.
Able to apply specialized knowledge in Proficy MS SQL DBA - MS SQL 2012 or Higher but Prefer Experience with 2016 High Availability.
The expectations for the Application DBA in Proficy would include (but not limited to) :
Monitoring DB Activity
Monitoring DB Performance
Being available to Service Desk team to provide DB help and assistance to sites and on issuesEnabling trace Analyzing trace resultsAnalyzing DB activitiesAnalyzing DB performanceDetermining if / how DB is impacting issuesRecommending corrective actions to resolve issue and / or help siteImplementing corrective action (when appropriate, authorized, and within power / authority)
Support and manage the Proficy databases.
Design and configure relational database objects (as / when needed).
Responsible for data integrity and availability.
Design, deploy servers (as needed).
Monitor database servers.
Design data distribution and data archiving solutions.
Ensure database security, including backups & disaster recovery.
Plan and implement application and data provisioning.
Maintain high transaction databases (Indexes, Disk Space, Database Growth)
Govern an Always On SQL Server Landscape
Create, Manage, Monitor, AdministerMaintain jobsRe-indexingDB and OS BackUp JobsStored procedureDisk space utilizationRoles and rightsServer PerformanceJobs & DB SecurityAdd drop tablesGrow databasesRemove record blocking or lockingMonitor for long running jobsDatabase tuningStored procedure creationHigh Availability, replication, failoverMS DBA CertificationsMonitor server performance (trend over time capacity planning)Restore data -
point in time and entire databases
Education and Experience Required :
Typically, a technical bachelor’s degree in information systems, computer science, or related field and a minimum of 6 years of related experience or a master’s degree and a minimum of 4 years of experience.
Knowledge and Skills :
Experience in Microsoft SQL BI solutions, architecture, design, development, data engineering, data warehousing, and data management.
Data models, dimensional maintenance, and TSQL development in high-performance environments required. Experience in SSIS Particularly using C# scripting object, C#, .
Net with MVC, ClickOnce, and TFS or SVN experience
Experience in Microsoft SQL reporting solutions and development experience in T-SQL, stored procedures, complex reporting query development, query optimization, and DevOps
4+ years of technology services and business operations experience in a technology services organization
Experience in multiple solution development methodologies and participation in a fast paced, Dev / Ops environment
Experience in scorecard, dashboard and business analytics solutions for executive information reporting, analysis and decision support
Excellent analytical thinking, technical analysis, and data manipulation skills.
Ability to leverage new analytical techniques to develop creative approaches and insights.
Can validate / evaluate if an information systems or operational architecture meets business needs.
Be able to evaluate the effect of external factors on designed solution.
Data, analytics and systems subject matter expert on leading financial, workforce and services solutions
Advanced understanding of modern software design and development methodologies. Experience on multiple major full release project life cycles.
Advanced understanding of modern SCM (software configuration management). Advanced understanding of testing tools and unit test and integration test scripting, and testing methodologies.
Advanced experience using an Integrated Development Environment (e.g., Eclipse, Visual Studio) and development of tool add-ins.
Experience in defining quality and security standards.
Ability to work effectively in a globally dispersed team. High level of technical leadership skills.
Strong verbal and written communication and negotiation skills. Strong project management / team leader skills. Excellent oral and written communication skills for interacting with stakeholders.
Strong presentation skills.
Expert analytical skills and the ability to synthesize change quickly using advanced subject and process knowledge. Excellent time management skills and ability to prioritize
Ability to generate original ideas and to bring about their implementation.
Knowledge of and ability to utilize a variety of tools and technologies to support multiple technologies.