Operational DBA for over 50 MsSql instances

-Assisted in daily DBA operations, master data fixes, schema changes, user access to data, monitor of agent jobs/alerts.-Migrated databases across servers (SCSM, SCCM included) all under 1TB in size.-Maintained availability groups, clustered instances, ensured safe/continuous failovers.-Backup, restore, clone OLTP databases to Dev/Prod instances.-Setup SSIS packages; persist data and ETL. -Managed (OLAP) SSAS multi-dimen cubes also (OLTP) for SSRS reporting, Tableau implementation, ad-hoc queries for BI.-Version control with Git/Sourcetree, ticket tracking with SCSM, schema control with VisualStudio/dbschema.

-Develop, administer, and maintain Digital Risk enterprise data warehouse.-Monitor table indexes/constraints/relations, table and db backups.-Generate SQL Server stored procedures, views, and queries to be utilized by Analyst teams.-Ensure that SSRS reports are developed to meet quality goals and are completed within established timelines and budgets.-Design ETL processes for varying sources of data with SSIS.-Use of Source Control for stored procedures and SSRS rdl files.-Sharepoint 2010/2013, Microsoft Sql Server 2008 R2/2012: SSMS, SSRS and SSIS.-Dundas development with C#.

-Communicate with internal and external customers to scope, develop, test, implement and maintain integration processes.-Establish logical and programmatic relationships between different cross-departmental database driven systems.-Deliver systems integrations and means of interface among divergent and/or competing systems.-Monitor and support EDI environment.-DB2v9.5, SQLServer2008-T-SQL, PL/SQL, EDI, XML

-Create applications/dashboards in Oracle APEX as well as MS ACCESS for end-users to interface with their data.-Create PL/SQL scripts for reports in Oracle databases with either SQL-PLUS, Oracle Developer or MS Access.-Meet with clients to determine and define needs in terms of reporting pertinent data.-Serve as a backup for the Sr.DBA in an Oracle 10g/11g environment (39gb-PROD& 39gbTEST), some SQL Server 2005.-Backup and update SQL Server, Tomcat, Oracle databases.-Administer Banner middleware, run upgrades and patches, test forms and functionality before production.-Administer Oracle/Banner database users, assigning/adjusting access and privileges.-Extract data from Oracle databases to submit to State and Federal agencies.-Upload data from Oracle databases into SQL Server databases.-Write and maintain documentation to describe program development, logic, coding, testing, revisions.-Tailor apps from Blackboard, HigherOne, and Evisions to interact with Oracle and Banner.-Liaise with 3rd party clients at Sungard, Bluefin Tech apps, Blackboard, HigherOne.-Administrate Blackboard, HigherOne and Elumen systems data.-Meet with department heads/managers monthly to discuss database issues/concerns/projects-Utilize test environments before applying revisions/updates/upgrades in production.-Administer student email in Windows Live@Edu.-Create Powershell scripts in administration of student email.

-Create reports using various software; DB2 Tools, SAS, QMF and Oracle-Hyperion Brio.-Data analysis of varying complexities in a DB2 environment.-Meet with clients to determine where the best data resides and the most efficient way to gather it.-Convert large sets of data from one system’s parameters/layout to fit another system.-Collect data from different sources; convert it, combine it, and assess its quality to create relevant reports.-Tune collected data; cleansing bad data to assure quality, validate accuracy by comparing to other systems. -Restore lost system data through use of backup FTP sites or hard copies.-List/Campaign management using; CRM/Siebel, FTP and AS/400-Generate SQL and JavaScript scripts in the aforementioned applications.-Some updating and troubleshooting web-pages in HTML, CSS, Javascript-Liaise with worldwide clients and team members in the Philippines, South America, and Europe.-QA/QC on scripts/queries, data briefs and reports.-Encryption of sensitive files.-Assign and manage workload in Team Leaders absence.-Assist in managing Helpdesk duties for North and South America Geos.