Database Administrator
Current• Designed and developed databases using relational database models for all internal business departments using SQL Server.• Developed web applications for data entry for internal departments using C# and ASP.net. • Configured database servers to ensure high availability and disaster recovery across multiple subnets.• Developed SSIS packages, Transact-SQL (T-SQL) and VB scripts for importing, manipulating and transferring data between multiple SQL Servers, SQL Server Instances and secure FTP servers.• Created and maintained tables, stored procedures, views, functions and triggers for SQL Server databases.• Maintained SQL Server security logins and roles.• Created and monitored jobs in SQL Server for backups, import, export and manipulation of data.• Developed and maintained reports for the following departments: Finance, Retailer Contracts, Retailer Services, Sales, Marketing and Communications using SQL Server Reporting Services and SQL Server Business Intelligence Development Studio.• Monitored and tuned SQL Server databases and queries for optimal performance.• Managed confidential incoming and outgoing retailer and financial data to and from outside agencies.• Documented all database and report structures for audits.• Responsible for automation of maintenance jobs, locks and indexes configurations.• Responsible for the management of the database performance, backup and security.